Transpose link
Put this in B1:
=INDEX(C$1:M$1,ROW(A1))
and copy down. Adjust the range C1:M1 to suit how far you want to copy
it down.
Hope this helps.
Pete
On Jun 3, 11:20*am, "Ana via OfficeKB.com" u51486@uwe wrote:
Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
corner of a cell. I will automaticly link
A1 - C1
A2 - C2
A3 - C3 ect
My question is if it is possible to drag horisonal and link vertically???
A1 - C1
A2 - D1
A3 - E1
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1
|