MACRO to split data into multiple sheet
Closed
Report
kittyluting22
TrowaD
- Posts
- 1
- Registration date
- Monday June 26, 2017
- Status
- Member
- Last seen
- June 26, 2017
TrowaD
- Posts
- 2829
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 22, 2021
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
- Posts
- 2829
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 22, 2021
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
