software

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 quot;move or copy...quot;. If
you want to copy the sheet, make sure you select the quot;Create a copyquot; box.

quot;Tomquot; wrote:

gt; We have a workbook with ten (10) woorksheets and have the need to extract a
gt; single worksheet.
gt;
gt; Is there a way, other than cutting and pasting to a blank worksheet to
gt; extrract the single page?
gt;
gt; Thanks

Hi Tom,

On the worksheet tab, right click =gt; 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.

quot;Tomquot; wrote:

gt; We have a workbook with ten (10) woorksheets and have the need to extract a
gt; single worksheet.
gt;
gt; Is there a way, other than cutting and pasting to a blank worksheet to
gt; extrract the single page?
gt;
gt; Thanks

quot;Tomquot; lt;Tom gt; wrote in message
...
gt; We have a workbook with ten (10) woorksheets and have the need to extract
gt; a
gt; single worksheet.
gt;
gt; Is there a way, other than cutting and pasting to a blank worksheet to
gt; extrract the single page?

Edit menu: Move or copy sheet
--
David Biddulph
Thanks all

quot;David Biddulphquot; wrote:

gt; quot;Tomquot; lt;Tom gt; wrote in message
gt; ...
gt; gt; We have a workbook with ten (10) woorksheets and have the need to extract
gt; gt; a
gt; gt; single worksheet.
gt; gt;
gt; gt; Is there a way, other than cutting and pasting to a blank worksheet to
gt; gt; extrract the single page?
gt;
gt; Edit menu: Move or copy sheet
gt; --
gt; David Biddulph
gt;
gt;
gt;