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
Only Copy Subtotals 8
Copy to Visible Cells only;Modify Code 11
Copying only subtotals 1
Code to calculate only visible cells 1
Visible rows copy to different worksheet 5
Copy visible cells after filtered paste to first empty cell 1
select only used rows and only visible cells 2

Top