newbie question

  • Thread starter Thread starter dickyh
  • Start date Start date
D

dickyh

Total newbie question-

Sorry this is so basic, I am a bit dim.

I have one worksheet of data that contains long distance rates t
hundreds of destinations.

When those rates, I want the changes to be reflected in othe
workbooks.

Say I want cell a1 to use the data in "Rates a1" and add 3 to it, i
the new workbook cell I would put ='Rates'!$a$1+3.

However, if I then want to copy that formula to a2 but reference th
data in a2 in "Rates a2", how do I do that?

Thank
 
Hi

You need to use relative rather than absolute references. Just drop the
dollar signs:
='Rates'!A1+3
You can then use AutoFill down the column as you wish.
 
A further refinement might be to hard-code a cell reference instead of the
number 3.

That way when you make a change in the hard-coded cell, all rates would
change.

='Rates'!A1 + 'Rates'!$B$1 (note the $ signs in $B$1)

Change B1 on Rates sheet from 3 to 5 and all linked cells will change.

Gord Dibben Excel MVP
 
Back
Top