Thread: how to copy named sheets to separate workbooks with same name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dawn Bjork Buzbee Dawn Bjork Buzbee is offline
external usenet poster
  
Posts: 10
Default 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
Reply With QuoteReply With Quote