coping Subtotal

  • Thread starter Thread starter Erle
  • Start date Start date
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
 
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
 
Back
Top