Copying Subtotals to new worksheet

C

carl

I have a worksheet full of data. I have used the subtotal function and want
to copy across just the subtotals to a new worksheet. I can't seem to only
copy the subtotals. When I collapse the subtotal sidebar so that the sheet
only shows the subtotals and then try copying them it copies over the
collapsed side bar to so I can still reveal the full data again.

Can someone please help?
 
D

Dave Peterson

After you've hidden the details
select the range to copy
edit|goto|special|Visible cells only

Then do the copy|paste
 
D

Duke Carey

After selecting the subtotal rows, press the F5 key, click on the Special
button, and select "Visible cells only" and then click OK. You should see
the marquee around the selection change to indicate that the hidden rows are
no longer selected. Now you can Copy & Paste only the subtotals
 

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

Top