how to copy named sheets to separate workbooks with same name
 

On a monthly basis, I extract data from one worksheet to individual sheets
per each customer-the macro to do this works great.

Any ideas on the best way to automatically save each of the 75+ sheets to
individual workbooks using the sheet name as the file name?

--
Thanks in advance,
Dawn Bjork Buzbee

how to copy named sheets to separate workbooks with same name
 

Hi Dawn

Try this one
http://www.rondebruin.nl/copy6.htm

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


"Dawn Bjork Buzbee" wrote in message
...
On a monthly basis, I extract data from one worksheet to individual sheets
per each customer-the macro to do this works great.

Any ideas on the best way to automatically save each of the 75+ sheets to
individual workbooks using the sheet name as the file name?

--
Thanks in advance,
Dawn Bjork Buzbee

how to copy named sheets to separate workbooks with same name
 

Ron,
Excellent! Worked perfectly. I have added your Excel tips site to my group
of resources. Thanks again for your helpful expertise! Dawn
--
Dawn Bjork Buzbee
Lots of end-user tips at: www.SoftwarePro.com

"Ron de Bruin" wrote:

Hi Dawn

Try this one
http://www.rondebruin.nl/copy6.htm

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


"Dawn Bjork Buzbee" wrote in message
...
On a monthly basis, I extract data from one worksheet to individual sheets
per each customer-the macro to do this works great.

Any ideas on the best way to automatically save each of the 75+ sheets to
individual workbooks using the sheet name as the file name?

--
Thanks in advance,
Dawn Bjork Buzbee