Thread: set up a macro to copy/ move sheets to individual files
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default set up a macro to copy/ move sheets to individual files
Try this macro
http://www.rondebruin.nl/copy6.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Danielle44" wrote in message ...
I have a workbook that includes commission sheets for 10 sales people. I
want to create a macro that will move a copy of each sheet to its individual
file. How do I do that with out going to each file and moving each sheet
individually?

Thank you.


Reply With QuoteReply With Quote