Macro to create worksheets and copy data from a summary page
Closed
annamcd
Posts
1
Registration date
Thursday April 13, 2017
Status
Member
Last seen
April 13, 2017
-
Apr 13, 2017 at 09:46 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 25, 2017 at 06:27 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 25, 2017 at 06:27 AM
I have a workbook called Sales Commission and sheet 1 is my summary page. I want to write a macro that will look at the summary page and from column 1 where the sales persons name is create a new worksheet (sheet2, sheet 3 etc) called by the salespersons name and to copy the data from rows A to K onto the new sheet relevant to that salesperson. I also want it to omit row F from the new sheet.
Can anyone help me as I'm stuck.
I'd be very grateful.
Can anyone help me as I'm stuck.
I'd be very grateful.
Related:
- Macro to create worksheets and copy data from a summary page
- Transfer data from one excel worksheet to another automatically - Guide
- Create skype account with gmail - Guide
- Tmobile data check - Guide
- Mint mobile data not working ✓ - Network Forum
- Create snapchat account - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Apr 25, 2017 at 06:27 AM
Apr 25, 2017 at 06:27 AM
Hello Anna,
Do you still need help with your query or have you managed to sort it out?
Cheerio,
vcoolio.
Do you still need help with your query or have you managed to sort it out?
Cheerio,
vcoolio.