Macro to create worksheets and copy data from a summary page

[Closed]
Report
Posts
1
Registration date
Thursday April 13, 2017
Status
Member
Last seen
April 13, 2017
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
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

Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
Hello Anna,

Do you still need help with your query or have you managed to sort it out?

Cheerio,
vcoolio.