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

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.

"Tom" wrote:

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

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.

"Tom" wrote:

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

"Tom" <Tom wrote in message
...
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
--
David Biddulph

Thanks all

"David Biddulph" wrote:

"Tom" <Tom wrote in message
...
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
--
David Biddulph