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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Cells in List 2
Copy subtotals 1
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL 1
subtotals copying 3
keeping subtotals accurate to reflect sorting... 1
subtotal within subtotal 5
DELETING SUBTOTALS FROM A COLOMN 1
Using Subtotals in Other Sheets 7

Top