MACRO to split data into multiple sheet

Closed

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: 2888
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: August 16, 2022

- 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
Macros: Copy Invoice Details From One Sheet to Another ✓ - Forum - Excel

1 reply

Answer 1 / 1

TrowaD

Posts: 2888
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: August 16, 2022

515
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

Subscribe To Our Newsletter!