Excel - Paste into a range of hidden rows; in the right order?

[tcarroll5601]

I have a range of 35 or so cells that I need to copy. I copy the cells, and I want to paste them (in the original order) into another excel sheet that has multiple hidden rows. I select GoTo>Special>Visible Rows Only on the sheet that I want to paste into. But, when I paste my data, the top cell just repeats all the way down! Is this even possible to do in excel using the visible rows only feature? Help!

 

[Gavona]

I don't believe it is possible... What is more you have almost certainly copied into the hidden rows. You will need to copy each row individually. If this is a regular task then a macro could help you -->> forum707

Gavin