Copy and Paste subtotlals

Giganews Newsgroups
Subject: Copy and Paste subtotlals
Posted by:  Daniel - Sydney
Date: Wed, 3 May 2006

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

Replies