how to copy visible cells data only.

G

Guest

i need to copy only the data that is visible and want to
ignore the hidden cells data. can any one help

thanks,

immu
 
M

Max

Try ..

Press F5 > Special > Visible Cells only > OK
Then copy > paste to destination sheet
 
Top