how do you paste just specific info and not the hidden info?

J

JLovato

i am trying to just copy over the final totals associated with each employee
but when i paste it i gives me all the hidden cells.
 
D

Don Guillett

Macro - Have a look in vba help for SPECIALCELLS
Formula - copy>touch f5 key goto special>visible
 
G

Gord Dibben

Try F5>Special>Visible cells only>OK

Copy those selected.


Gord Dibben Excel MVP
 
Top