I dont want to copy hidden rows

[sh0t2bts]

Hi All,


I have a spreadsheet that depending on what is entered in to cell A1 it
hides certain rows from row 20 through to row 300, what I want to now do is
copy what rows are left unhidden and paste them onto another sheet..


How would I do this cos every time I have tried it I paste all 300 rows?


Many Thanks

Mark

 

[Juan Sanchez]

Once you have selected all 300 rows , including the hidden
ones, go to EDIT > GOTO > SPECIAL > VISIBLE CELLS ONLY > OK

This will unselect hidden rows, then copy and paste...

Regards
JS

 

[sh0t2bts]

simple when you know how!!


Many Thanks


Mark

Once you have selected all 300 rows , including the hidden
ones, go to EDIT > GOTO > SPECIAL > VISIBLE CELLS ONLY > OK

This will unselect hidden rows, then copy and paste...

Regards
JS