formula autofill problem

[obrien2003]

Maybe a simple question to somebody. Trying to increment autofill formula. (A1 to A12). with values from B2 to G2 (1 row). Column A formula won't increment coulum formula.
Attached.

[DonkeyOte]

Sorry I don't understand - you have six values in B2:G2 and you want to increment them across 12 rows (A1:A12) how exactly ?

[obrien2003]

Sorry. The problem is so simple, I am prob making it more hard than it needs to be.

Formula in A1 (=B$2). Want to pull down autofill.
Values in B2, C2, D2, etc...

When I pull down... "B" wont incremnt to C, D, etc...

[karan]

A little more clarity might help.

Formula in A1 (=B$2). Want to pull down autofill.

I can't find it in the attached file.

[obrien2003]

Yes. When I pull the bottom right corner to autofill the formula, I wasm hoping it would change to "=C$2", Then to "D$2", etc... it is not...

[DonkeyOte]

You can use INDEX

A1: =INDEX($B$2:$G$2,ROWS(A$1:A1))
copy down

my original point holds though insofar as once you get to A6 you have no more values to transpose

[martindwilson]

try
=INDEX($B$2:$IV$2,ROWS($A$1:A1))
sort of "snap" there i think lol

[DonkeyOte]

kind of except I had failed to make the row refs absolute so mine would have failed...oops