coping Subtotal

E

Erle

Hi all

I was woundering if there is a way to do a "copy - paste specail- values" to
a list of subtotals with hidden rows onto a different worksheet with out
having excel open the hidden rows.

Thanks
Erle
 
A

Andy Brown

With one of the cells selected, select the region (CTRL+Shift+*). F5 --
Special -- Visible Cells Only -- OK. Then do your copy & paste (you only
need Paste Values if you want to lose the formatting).

Rgds,
Andy
 

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

Drop down list control value in vba 2
Additonal info into newly created Subtotal row 1
Vlookup a subtotal 2
Hidden cells 1
Need array formula to ignore hidden values 1
Create a dynamic master file 1
Can I use the subtotal function while a worksheet is protected? 0
Embed the same Excel multiple times 0

Top