Hi,
i tried the below solution which ui had give. It works only for that
cell. I htought this logic will work if implemented in any cells..

Here's the details of that.

Cell M3 & N3 contains some word. simillary in cell M4 & n4 ..upto the cells
M90 & N90.

I wanted the value of M3 in M100 and value of N3 in M101; value of M4 in
M102 & value of N4 in M103. and so on...

Thanks in Advance,
Venkat.

"Debra Dalgleish" wrote:

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