Try this for evens:

=INDEX(Sheet2!A:A,2*ROWS($1:1))

And copy down as needed.

For odds:

=INDEX(Sheet2!A:A,2*ROWS($1:1)-1)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"questioningj" wrote in message
...
I have tried various ways to increment a formula from one tab to another.
Is
there a way to increment a formula being reference on another tab by odds
and
evens?
ex. =Sheet2!A2, = Sheet2!A4, etc