Extracting a Single Worksheet froma Mutipage Workbook

T

Tom

We have a workbook with ten (10) woorksheets and have the need to extract a
single worksheet.

Is there a way, other than cutting and pasting to a blank worksheet to
extrract the single page?

Thanks
 
J

Joe Tapestry

right click on the tab of the target worksheet. Select "move or copy...". If
you want to copy the sheet, make sure you select the "Create a copy" box.
 
E

ewan7279

Hi Tom,

On the worksheet tab, right click => Move or Copy, select the 'Create a
copy' box and '(new book)' in the dropdown menu. This will create a new
workbook containing this sheet. Be aware that any links in this sheet will
still look at the original workbook.

Ewan.
 
D

David Biddulph

Tom said:
We have a workbook with ten (10) woorksheets and have the need to extract
a
single worksheet.

Is there a way, other than cutting and pasting to a blank worksheet to
extrract the single page?
Click to expand...

Edit menu: Move or copy sheet
 
Top