set up a macro to copy/ move sheets to individual files
 

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.

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.