Extracting a Single Worksheet froma Mutipage Workbook

[Guest]

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

 

[Guest]

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.

 

[Guest]

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.

 

[David Biddulph]

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?

Edit menu: Move or copy sheet

 

[Guest]

Thanks all

Edit menu: Move or copy sheet