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
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
- 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.

1 reply

vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
249
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.
0