Enter the following formula in cell A10, and copy down:

=OFFSET($E$5,INT((ROW()-10)/2),MOD(ROW(),2))

Venkatesh V wrote:
Hi,
Take an Example:
the follwoing cells in an excel sheet contain the below values.
Cell E5 =1, cell F5=2
Cell E6 =3, cell F6=4
Cell E7 =5, cell F7=6
Cell E8 =7, cell F8=8


Now, select the row named: A10. write the formula as "=E5" Result is 1
select the row named: A11. write the formula as "=F5" Result is 2.

now select A10 & A11. Hold the mouse pointer at the bottom-right corner of
hte cell A11 and drag it to two or more cells.

I want the result to be

A12=E6
A13=F6
A14=E7
A15=F7
A16=E8
A17=F8

and so on...


Thanks in advance for your solutions
Venkatesh V


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html