How do I save a page in a workbook as a separate file?
 

I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.

How do I save a page in a workbook as a separate file?
 

Save the many sheeted workbook with the new name
Now delete the unwanted sheets - right click each tab and use Delete
If you have lots of tabs: click the first one that is to go; hold SHIFT;
click the last one (do not include the required sheet); the right click and
delete
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"flowv" wrote in message
...
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.

How do I save a page in a workbook as a separate file?
 

Hi

Right click on the Sheet tab requiredMove or Copyclick CopySelect New
Workbook from the dropdown.
You will now be in a new workbook with that sheet included.
Save with whatever name you want

--
Regards
Roger Govier

"flowv" wrote in message
...
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.

How do I save a page in a workbook as a separate file?
 

Hi flowv

You can use this macro
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"flowv" wrote in message ...
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.

How do I save a page in a workbook as a separate file?
 

Oops, you only want to save one sheet I see now.
Forget my reply



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Hi flowv

You can use this macro
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"flowv" wrote in message ...
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.