I have a master sheet for each one of my reps and when I copy and paste, it
will not change the formulas to coincide with the rep name. i made the
master on rep 1 when I copy the master into rep 2's file, all the formulas
still read rep1, can i paste the master w/o having to change all the formulas
to rep2 and so on?