copy sheets to workbook and save as sheet name

U

umpire_43

Hi There,

I have a spreadsheet over 40 sheets. What i like to do is to:
1) copy each sheet into its own workbook
2) name that workbook that matchs the sheet name
3) User selects the directory where the first file is saved and saves the
directory for the rest of the sheets within the workbook
4) Closes the saved workbook that has one sheet in it

Can you help?
thanks
 

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

Visio: copy text of a master shape to User-define Cells (Variable) 0
selecting workbook/sheet 3
Copy range from multiple files in multiple folders to single sheet in master WB 10
linking sheets and workbooks 0
Open four Wbooks, copy four columns from each to Master Wbook 16
Copy cell value from one worksheet to matching worksheet in another workbook 4
Code copies twice...? 13
Save and closed excel workbook from the sheet 1

Top