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