How do you copy saved excel sheets to a new workbook

C

chrisnsmith

I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy
these
sheets to a new workbook?
 
R

Rasoul Khoshravan

I'm using Ron De Bruin's code to copy worksheets to a folder.  How can I copy
these
sheets to a new workbook?
Click to expand...

A simple way could be to copy the file, name it and then delete the
extra sheets you don't need.
 
D

David Biddulph

Right-click on the tab for a sheet, then choose "Move or Copy Sheets", and
choose which workbook you want as the destination for the copy.
 
G

Gord Dibben

You can't save just a sheet to a folder so you must be mis-interpreting the
function of Ron's code.

His code probably copies one sheet from a workbook to a new workbook before
saving to a folder.

Post the URL for the code from Ron's site.


Gord Dibben MS Excel MVP
 
Top