Mike,

In sheet2 A1, enter

=INDEX(Sheet1!A:A,ROW()*2-1)

and copy down as far as you need.

HTH,
Bernie
MS Excel MVP


"Michael E. Gibson" wrote in message
...
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