Creating different sheets in same workbook from master sheet [Closed]

Report
-
Posts
2691
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 14, 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
2691
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 14, 2021
454
Hi Nabeel,

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

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!