Fill Options & Formula Help

  • Thread starter Thread starter 0greeny0
  • Start date Start date
0

0greeny0

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
 
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
 
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.
 
Back
Top