Fill Options & Formula Help
 

I am trying to drag a formula across many cells from a seperate spreadsheet,
however i am having a few difficulties.

On the second sheet i am wanting to fill cells horizontally (a1, a2, a3 etc)
with information from the first sheet (a1, b1, c1, d1 etc).

For some reason i cannot do this without manually going through and changing
the formula.

Is there a way this could be acheived?

Thank you

Fill Options & Formula Help
 

GOto sheet2 cell a1
Type the "=" to start the formula
Switch back to sheet1, select cell A1, press enter
Now use your normal fill handle to replicate this formula across sheet2

HTH
"0greeny0" wrote:

I am trying to drag a formula across many cells from a seperate spreadsheet,
however i am having a few difficulties.

On the second sheet i am wanting to fill cells horizontally (a1, a2, a3 etc)
with information from the first sheet (a1, b1, c1, d1 etc).

For some reason i cannot do this without manually going through and changing
the formula.

Is there a way this could be acheived?

Thank you

Fill Options & Formula Help
 

To transpose like that you need to use a slightly more complicated formula


Put this in A1 on the second sheet
=INDEX(Sheet1!$A$1:$A$40,COLUMN())

and drag to fill.

NOTE: Change the $A$40 to fit the end of your range.
--
If this helps, please remember to click yes.


"0greeny0" wrote:

I am trying to drag a formula across many cells from a seperate spreadsheet,
however i am having a few difficulties.

On the second sheet i am wanting to fill cells horizontally (a1, a2, a3 etc)
with information from the first sheet (a1, b1, c1, d1 etc).

For some reason i cannot do this without manually going through and changing
the formula.

Is there a way this could be acheived?

Thank you