Copy only visible cells after applying "Subtotals"

H

H.G. Lamy

Hello,

in an XL-list I need to copy only a block of subtotals to another area,
without the detail rows in between. I believe there once was a command like
"paste only visible cells" (or similar), but I can't find a solution.
Anybody who knows how to do this ?

Thank you in advance,

H.G. Lamy
 
D

Dave Peterson

You can copy the visible cells.

Show just the subtotals
select the range to copy
Edit|goto (or F5 or ctrl-g)|special|visible cells only

Then edit|copy
and paste where you want.
 

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

Copy Visible Cells and paste in another workbook visible cells only 5
how to copy and paste "averages" 4
Select and copy only cells with values, open an app, paste into 2
Copy to Visible Cells only;Modify Code 11
Code to calculate only visible cells 1
Only Copy Subtotals 8
I copied Visible Cells Only, but it pastes only the first cell 1
autofill to visible cells only 5

Top