Data subtotal

[Guest]

I am using Excel 2000

Once Data subtotal is performed on a set of data, is there a way of copying and pasting only the subtotal

What about in Excel 2003?

 

[Frank Kabel]

Hi
try the following after applying subtotals
- Group the data (clicking on the '-' grouping symbol) so that only the
subtotal rows are visible
- select the data range
- hit F5, click 'Special' and choose 'Only visible cells'
- now copy (e.g. hit CTRL+C)
- paste your data

--
Regards
Frank Kabel
Frankfurt, Germany

I am using Excel 2000.

Once Data subtotal is performed on a set of data, is there a way of

copying and pasting only the subtotal?

 

[Guest]

Thanks Frank.