Is there a way to fill a formula across columns (i.e., horizontally) but have the cell references in the formula increment the row number instead of the column?
I have a summary sheet that links to totals on back-sheets and this would speed up the linking of cells. Lets say A1's formula is
=Sheet2!G5. I want the value of B1 to be equal to
=Sheet2!G6 and NOT
How can I get Excel to do this?
Each row on my summary sheet needs to pick-up 3 values from a back-sheet.
I would like to save time by only manually setting A1
=Sheet2!G5 and A2
=Sheet3!G25 then somehow offsetting the values in B1,C1, B2, C2.