Enter this in A1, and drag down to copy as needed:
=OFFSET($D$1,,ROW(A1)-1)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Paweł Gałecki" wrote in message
...
How can you make Excel to advance one row instead of one column?
For example you in A1 you have:
:=D1
One after draggin it one cell below (A2)i would like to have
:=E1
instead of
:=D2
any clue??
|