coping of cell using dragging the cell downward or rightward

[Vimlesh]

If one cell e.g. A1contains formula =Q12 and one drag cell A1 downward, the
lower copied cell will contain formula =Q13, =Q14, =Q15......and so on. But
can we have the copied formula in this fashion:=R12, =S12, =T12......and so
on while dragging it downwards only.

And vise versa dragging the cell to right should contain =Q13, =Q14,
=Q15......and so on instead of :=R12, =S12, =T12......and so on.
THX

 

[Jim Cone]

In Cell A1...
=OFFSET($Q$12,COLUMN()-1,ROW()-1)
--
Jim Cone
Portland, Oregon USA
Excel add-ins: http://www.mediafire.com/PrimitiveSoftware





"Vimlesh" <[email protected]>
wrote in message
If one cell e.g. A1contains formula =Q12 and one drag cell A1 downward, the
lower copied cell will contain formula =Q13, =Q14, =Q15......and so on. But
can we have the copied formula in this fashion:=R12, =S12, =T12......and so
on while dragging it downwards only.

And vise versa dragging the cell to right should contain =Q13, =Q14,
=Q15......and so on instead of :=R12, =S12, =T12......and so on.
THX