Substitution of words
I have a worksheet that has a schedule of when people work and rather than
put the names in (as their job changes every 2-4 weeks), I put in the job,
then every month fill in the correct names from day to day. Is there a way
to subdtitute an entire worksheet name to another (ie written in is "clinic"
in multiple area and for the month of September "Joyce" is the person). Is
there a way to change all places that say "clinic" with "Joyce's" name rather
than going through each day and changing them.
|