copying formulas

[Guest]

I am trying to copy a formula by dragging it to cells in the same row. The
formula references a cell in a separate column. I want it to recognize that
everytime I drag the formula to the cell to the right it updates the formula
with the cell below the original one that was referenced

 

[Gord Dibben]

Assuming original formulas in Column A

In B1 enter this formula and drag across.

=OFFSET($A$1,COLUMN(A1)-1,)


Gord Dibben MS Excel MVP

 

[Guest]

Gord,
Thanks for responding unfortunately that doesn't work either. Let me try to
explain it again as I know the first time was somewhat unclear.

Example

Row Column A Column B Column C Column D Column E
1 1000 =A1 =A2 =A3 =A4
2 5000
3 3000
4 3500

So as you can see it is quite simple and hopefully there is also a simple
answer. I want to be able to drag the formula from B1 horizontally and have
it automatically reference cells vertically.

Thanks

 

[Gord Dibben]

Was perfectly clear to me.

My formula entered in B1 and dragged across will give you 1000, 5000, 3000, 3500
in B1, C1, D1 and E1

Did you try it?

You cannot drag =A1 across and have it increment as you describe.


Gord

 

[Guest]

I tried it again and it works. Thanks a million, this is going to save me a
lot of time.
Cheers