MACRO to split data into multiple sheet [Closed]

Question

MACRO to split data into multiple sheet [Closed]

Report

kittyluting22

Posts: 1
Registration date: Monday June 26, 2017
Status: Member
Last seen: June 26, 2017

- Updated on Jun 26, 2017 at 11:37 AM
TrowaD

Posts: 2702
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: March 2, 2021

- Jun 26, 2017 at 11:38 AM

I have a data sheet with below columns, would like a macro to split data into each tab according to cardholder_name if this is possible

Cardholder_Name Merchant Merchant_Location Date_Occurred Date_Posted Settlement_Amount

MACRO to split data into multiple sheet
Split data into multiple sheets using macro ✓ - Forum - Excel
Macro for merging data from multiple sheets ✓ - Forum - Excel
Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
How to auto populate data from multiple sheets to a master ✓ - Forum - Excel
Populate Multiple Sheets Based on Data Entered in a Main Excel Sheet - How-To - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2017-06-26T11:38:44-0400

Answer 1 / 1

TrowaD

Posts: 2702
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: March 2, 2021

457
Jun 26, 2017 at 11:38 AM

Hi Kittyluting22,

See if the following code does as requested:

Sub RunMe()
For Each cell In Range("A2:A" & Range("A1").End(xlDown).Row)
    cell.EntireRow.Copy Sheets(cell.Value).Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
Next cell
End Sub

Best regards,
Trowa

MACRO to split data into multiple sheet [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!