I have one main excel file that I update and have around 1000 rows.
From this sheet I create one pivot table for each sales person, so I have 11 sheets as it is 11 different people. (they will have their own sheet for their orders)
Now my question is. Can I easy create a new excel file for each sheet in the main file, so I can send it to them with email, when I have updated the main file.
So I would like to take each sheet and create a new excel file for each, so that would be 11 excel files.
I would like to have it as a macro, so it would be an easy take every day when I update the main file.
Dont know if it is possible but I take all advice how to make this work.
Bookmarks