I ran this formula in the odd rows of Sheet2, beginning with A1 and
referencing sequential cells on Sheet1, beginning with A1:
=OFFSET(Sheet1!$A$1,MAX(0,ROW(A1)/2),0)
So...
Sheet2!A1 refers to Sheet1!A1
Sheet2!A3 refers to Sheet1!A2
etc
Is that something you can work with?
--
Regards,
Ron
|