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