fill down

[afdmello]

if data is present in cells E18,F18,G18,H18....

Now , want this data from the above cells to be added in the following cells

M10 using the formula =E18
M11 using the formula =F18
M12 using the formula =G18
M13 using the formula =H18

I observed that I cannot use the fill handle to drag down. I tried to use the dollar sign i.e. M10 =E$18 but the same cell is filled down

How can this be accomplished without typing

Afd

 

[T. Valko]

if data is present in cells E18,F18,G18,H18....

Now , want this data from the above cells to be added in the following cells

M10 using the formula =E18
M11 using the formula =F18
M12 using the formula =G18
M13 using the formula =H18

I observed that I cannot use the fill handle to drag down. I tried to use the dollar sign i.e. M10 =E$18 but the same cell is filled down

How can this be accomplished without typing

Afd

Try this entered in M10 and copied down:

=INDEX(E$18:Z$18,ROWS(M$10:M10))

Adjust for the correct end of range in E$18:Z$18

 

[Weaver]

paste this formula into M10 and copy down

=OFFSET($E$18,0,ROW(A1)-1,1,1)

 

[afdmello]

Thank you Beaver and Biff
Both worked.
I will now need to learn the meaning of the formulas and internalize them

Afd

 

[T. Valko]

Thank you Beaver and Biff
Both worked.
I will now need to learn the meaning of the formulas and internalize them

Afd

You're welcome. Thanks for the feedback!