One way to get it dynamically transposed ..

In A10:
=OFFSET($A$1,COLUMN(A1)-1,)
Copy A10 to I10
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"C.A.S." wrote:
I need to copy a formula to the right and have the column in the formula
remain constant but the row increase by one for each column to the right I
go. For example if in cell A10 I enter =A1 then copy that to the cells to the
right, it makes cell B10 =B1 and I need it to =A2, C10 needs to =A3, etc.
Can someone help me understand how to do this? I tried =$a1 but that is
keeping the column and row constant.