In that case, you could use:

=INDIRECT("Sheet2!B"&INT(ROW()/2)+48)


"jijy" wrote:


Thanks a lot Elkar. I have one more question, What if the data in Sheet
2 is in the range B50:B190 and I want a formula on Sheet1 starting at
Cell A5 and every other cell below it (i.e. A5, A7, A8...)

Thanks

Jijy


--
jijy
------------------------------------------------------------------------
jijy's Profile: http://www.excelforum.com/member.php...o&userid=15042
View this thread: http://www.excelforum.com/showthread...hreadid=547969