Using autofill on cells with formulas

[jmancha]

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?

 

[mohadin]

Hi
is this what you mean

=INDIRECT("E"&ROW())

Or

=INDIRECT(ADDRESS(ROW(),COLUMN()+4))

 

[Fluff]

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

 

[jmancha]

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

 

[mohadin]

Have you try
=INDIRECT(ADDRESS(ROW(),COLUMN()+4))

 

[jmancha]

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.

 

[Fluff]

Have you tried the formula in post#3?

 

[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!!

 

[salim hasan]

Try this formula From Column(E) to Column(Z)

=INDIRECT(CHAR(69+ROWS($A$1:A1)-1)&1)

Or This One Column(E) to Any where

=OFFSET($A$1,,ROWS($A$1:A1)+3)

 

[Fluff]

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