Thread: Using autofill on cells with formulas Thanks: 0 Likes: 0

1. Using autofill on cells with formulas

Is there a way. . .

I am in Cell A1 and the formula is =E1. I want to copy my formula down but instead of the row # changing from E1, E2, E3, etc. I need the COLUMN to change from E1, F1, G1, H1, etc.

Is this possible?

2. Re: Using autofill on cells with formulas

Hi
is this what you mean
Code:
`=INDIRECT("E"&ROW())`
Or

Code:
`=INDIRECT(ADDRESS(ROW(),COLUMN()+4))`

3. Re: Using autofill on cells with formulas

=INDIRECT("R1C"&ROW()+4,0)

4. Re: Using autofill on cells with formulas

Thank you! The formula works in A1 but when I drag it to A2 the E does not change to F. . .

Have you try

6. Re: Using autofill on cells with formulas

It is still copying down the row but keeping the column the same. So, It is giving me E1, E2, E2 when I need E1, F1, G1, etc.

7. Re: Using autofill on cells with formulas

Have you tried the formula in post#3?

8. Re: Using autofill on cells with formulas

I did try all of them (thank you all). After trying those got me thinking. . . INDEX(\$1:\$1, 1, ROW(1:1))

This Worked!!

9. Re: Using autofill on cells with formulas

Try this formula From Column(E) to Column(Z)
Code:
`=INDIRECT(CHAR(69+ROWS(\$A\$1:A1)-1)&1)`
Or This One Column(E) to Any where
Code:
`=OFFSET(\$A\$1,,ROWS(\$A\$1:A1)+3)`

10. Re: Using autofill on cells with formulas

Originally Posted by jmancha
I did try all of them (thank you all). After trying those got me thinking. . . INDEX(\$1:\$1, 1, ROW(1:1))

This Worked!!
Glad you sorted it & thanks for the feedback