Copying subtotals from one sheet to another

C

Chris

I have a worsheet that I have subtotaled about 100 items.
I want to copy just the subtotals to another sheet. Every
time I try it, I get the details also. Please help.
 
F

Frank Kabel

Hi
try the following:
- select your range to copy
- hit F5, click 'Special' and choose 'visible cells only'
- now copy the data and paste the data
 
Top