View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ewan7279
 
Posts: n/a
Default Extracting a Single Worksheet froma Mutipage Workbook

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