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?


--
Trace

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


--


Regards,


Peo Sjoblom



"Trace" wrote in message
...
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?


--
Trace

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

On May 13, 3:44*pm, Trace wrote:
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?

--
Trace