Previous Topic Next Topic

Creating different sheets in same workbook from master sheet

Closed
Nabeel - Dec 21, 2016 at 02:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 22, 2016 at 11:31 AM
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.

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 22, 2016 at 11:31 AM
Hi Nabeel,

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

Best regards,
Trowa