View Single Post
  #1   Report Post  
Louise
 
Posts: n/a
Default changing cell references

Hi all

A colleague of mine has a large, complicated worksheet which contains
several large formulas.

Several of the formulas are referencing a particular cell, B4 for instance,
and he wants to change all the formulas to look at C3 instead.

I don't know if I can use a simple find/replace for this, as it's the
formulas themselves i want to change.

Is there a quicker way, rathr than changing them all manually???

Any urgent help is appreciated.

Thank you.

Louise