Thread: how to copy named sheets to separate workbooks with same name
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 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


Reply With QuoteReply With Quote