In the first cell, say cell C11, enter:

=INDIRECT("Sheet2!A" & (ROW(C11)-ROW($C$10))*2)

Note the relationship between the C11 and the $C$10....

Then copy down.

If you want to copy across, use Column instead of Row and $B$11 instead of $C$10....

HTH,
Bernie
MS Excel MVP


"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