Extracting a Single Worksheet froma Mutipage Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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 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
 
Back
Top