Save Current Sheet Only

[snax500]

I have a file that I use a pivot ( show pages) that creates 200 sheets
(customers). I then want to send each sheet out individually to each
customer. What is the easiest way to break up the file by each sheet
and save each sheet as an individual file?

Thanks

 

[Jim Thomlinson]

You will need a macro to do what you are asking for. There is still an issue
with even just doing that. The pivot tables created using show pages will
still contain all of the data for all customers. You need to ensure that you
only send the values and not the actual pivot table.

The macros will need to be custom built and will not be simple. If you are
not scared off yet then post back and we can point you in the direction of
some helpful web sites and other information...