Creating different sheets in same workbook from master sheet

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

I have data in master sheet from Column A to Column L and about 17,000 rows.
Column H contains the name of the sales persons.
I have to create excel sheet for each sales person with all column.
What code should I use.
Any suggestion please.

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Nabeel,

I would advise you to think about a different approach. Having 17,000 sheets is insane.

Best regards,
Trowa