MACRO to split data into multiple sheet
Closed
kittyluting22
Posts
1
Registration date
Monday 26 June 2017
Status
Member
Last seen
26 June 2017
-
26 Jun 2017 à 09:22
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Jun 2017 à 11:38
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Jun 2017 à 11:38
Related:
- MACRO to split data into multiple sheet
- How to split excel sheet into multiple worksheets - Guide
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Little alchemy cheat sheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
26 Jun 2017 à 11:38
26 Jun 2017 à 11:38
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
