worksheet formulas

[Trace]

I have a multiple work sheet set up. Trying to set up a formula to auto
update from 1 sheet to another. I have the formula set up for person # 1
(fred) and am trying to copy the formula to person # 2 (Chris) and so on.

So my formula reads Fred!M409 for Jan, Fred!M410 for Feb, Fred!M411 for
March etc. -- When I try to copy the formula for Chris it comes out reading
Fred!M409 for Jan, Fred!M410 for Feb, Fred!M411 for March etc. - when I want
it to read Chris!M409, Chris!M410, Chris!M411 etc. How do I get the formula
to auto update to the name?

 

[Peo Sjoblom]

How do you copy the formula given that you expect it to change to another
sheet name?


--


Regards,


Peo Sjoblom

 

[Pete_UK]

After you have copied it, highlight all the cells and do Find&Replace
(CTRL-H) to replace Fred with Chris, and so on for other sheets.

Hope this helps.

Pete