MACRO to split data into multiple sheet
Closed
kittyluting22
TrowaD
- Posts
- 1
- Registration date
- Monday June 26, 2017
- Status
- Member
- Last seen
- June 26, 2017
TrowaD
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Related:
- 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
TrowaD
Jun 26, 2017 at 11:38 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Jun 26, 2017 at 11:38 AM
Hi Kittyluting22,
See if the following code does as requested:
Best regards,
Trowa
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