Is there a way to have copy paste skip rows when copying a formula. Here's
what I am doing
Sheet 1 has data in
A1 data
A2 blank
A3 Data

On sheet 2 I need the data from A1 to go to A1 and the data from A3 to go
to A2 etc.
In an example Sheet 2 A1 reads "=sheet1!A1" Using copy makes the next line
read "=sheet1!A2". How can I make it skip to "=sheet1!A3" in A2?

Thanks
Mike