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

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

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

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

On Tue, 31 Jul 2007 15:50:02 -0700, aevans
wrote:

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

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

"Gord Dibben" wrote:

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

On Tue, 31 Jul 2007 15:50:02 -0700, aevans
wrote:

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