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.

Substitution of words
 

Select the range (or the entire sheet), then click Edit Replace
Find what: clinic
Replace with: Joyce
Click Replace All
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jkowalik" wrote:
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.

Substitution of words
 

How about replace?, edit, replace, find what clinic replace with Joyce,
replace all

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"jkowalik" wrote in message
...
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.