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" wrote:

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

On Tue, 31 Jul 2007 14:46:04 -0700, aevans
wrote:

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