View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
snax500 snax500 is offline
external usenet poster
 
Posts: 49
Default Save Current Sheet Only

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