Autopopulate sheets from summary page
Closed
cmarie88
Posts
1
Registration date
Tuesday June 13, 2017
Status
Member
Last seen
June 13, 2017
-
Jun 13, 2017 at 03:27 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 19, 2017 at 11:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 19, 2017 at 11:41 AM
Related:
- Autopopulate sheets from summary page
- Sheets right to left - Guide
- Summary slide powerpoint - Guide
- How to move between sheets in excel - Guide
- Excel copy data from one sheet to another - Guide
- Little alchemy cheat sheets - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 19, 2017 at 11:41 AM
Jun 19, 2017 at 11:41 AM
Hi Cmarie88,
Make sure that the 3 Sold by options and the 4 Project managers have their own sheet already created.
Then run the code below:
Have you tried using the filter option? It basically does the same but keeps the data on the same sheet.
Best regards,
Trowa
Make sure that the 3 Sold by options and the 4 Project managers have their own sheet already created.
Then run the code below:
Sub RunMe() Sheets("Summary").Select For Each cell In Range("B2:B" & Range("B1").End(xlDown).Row) cell.EntireRow.Copy Sheets(cell.Value).Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Sheets(cell.Offset(0, 1).Value).Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Next cell Application.CutCopyMode = False End Sub
Have you tried using the filter option? It basically does the same but keeps the data on the same sheet.
Best regards,
Trowa