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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 26, 2017 at 11:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 26, 2017 at 11:38 AM
Related:
- MACRO to split data into multiple sheet
- How to copy data from one sheet to another in excel automatically - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- Allow multiple downloads chrome - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jun 26, 2017 at 11:38 AM
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