how to copy named sheets to separate workbooks with same name

  • Thread starter Dawn Bjork Buzbee
  • Start date
D

Dawn Bjork Buzbee

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking sheets and workbooks 0
Emailing a sheet from a workbook with VBA 0
VBA loop to create named .csv files for all worksheets and workbooks in a folder 11
Copy range from multiple files in multiple folders to single sheet in master WB 10
Macro to copy row based on value into new sheet of same name 9
Search , then copy and paste from multiple worksheets. VBA help 1
Name the range AFTER copied to new sheet 6
Help with copying a sheet from One workbook to another workbook 1

Top