Copying a formula,

  • Thread starter Thread starter Keith Blake
  • Start date Start date
K

Keith Blake

Hi again,
Say I have in D7
=IF(B7="","",INDEX(Paul!D7:D34,MATCH(9.99999999999E+307,Paul!D7:D34))
and I want to copy that formula down from D8 to D34 but I want to keep
D7:D34 (in the formula)THE SAME,
currently it jumps to D8:D35 then D9 to D36 etc
all I want to change is the name of the sheet (EG: Paul (in D7) to Mick (in
D8) to Asher (in D9) etc.
The changing of the name I can do manually, but changing D8:D35 back to
D7:D35 is a major pain!
So basically I want to copy and paste the formula but not have it auto
adjust ? for the new column...
Hope I made myself clear.
Thanks
Keith Blake
(e-mail address removed)
 
Hi Keith,

D8 is a relative address. $D$8 is an absolute address; it will not change
when you copy.
You can either type it, or edit the formula, place the cursor in the address
and press F4.
An even easier way is to use a defined name (Insert>Name>Define) for the
range.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Thank You Niek...
Works great...

Niek Otten said:
Hi Keith,

D8 is a relative address. $D$8 is an absolute address; it will not change
when you copy.
You can either type it, or edit the formula, place the cursor in the address
and press F4.
An even easier way is to use a defined name (Insert>Name>Define) for the
range.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
Click to expand...
 
Back
Top