software

Hi

I am using XL 2002 SP3

I have a spreadsheet showing the totals of each days production of several
products,
each product appears several times in the spreadsheet.
I need to work with just the total of each product so I have done a sub
totals operation.
I now have the spreadsheet showing only the total of each product, how can I
copy this to a new spreadsheet without taking all the background data into
the new spreadsheet.

thanks

Highlight the desired region you wish to copy;
Press F5, Special-Button, then check Visible Cells Only; OK
Copy and Paste to whereever you want..
That should do it..
HTH

quot;Daniel - Sydneyquot; wrote:

gt; Hi
gt;
gt; I am using XL 2002 SP3
gt;
gt; I have a spreadsheet showing the totals of each days production of several
gt; products,
gt; each product appears several times in the spreadsheet.
gt; I need to work with just the total of each product so I have done a sub
gt; totals operation.
gt; I now have the spreadsheet showing only the total of each product, how can I
gt; copy this to a new spreadsheet without taking all the background data into
gt; the new spreadsheet.
gt;
gt; thanks

Jim

thanks for your help.

regards

quot;Jim Mayquot; wrote:

gt; Highlight the desired region you wish to copy;
gt; Press F5, Special-Button, then check Visible Cells Only; OK
gt; Copy and Paste to whereever you want..
gt; That should do it..
gt; HTH
gt;
gt; quot;Daniel - Sydneyquot; wrote:
gt;
gt; gt; Hi
gt; gt;
gt; gt; I am using XL 2002 SP3
gt; gt;
gt; gt; I have a spreadsheet showing the totals of each days production of several
gt; gt; products,
gt; gt; each product appears several times in the spreadsheet.
gt; gt; I need to work with just the total of each product so I have done a sub
gt; gt; totals operation.
gt; gt; I now have the spreadsheet showing only the total of each product, how can I
gt; gt; copy this to a new spreadsheet without taking all the background data into
gt; gt; the new spreadsheet.
gt; gt;
gt; gt; thanks