If there is some common element you could use Find/Replace, but unlikely, so
it is probably one by one.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bill R" wrote in message
...
I could probably use the salesman's name field and test wether it is blank
or
not. I have multiple formulas in the worksheet. How can I change them all
at
once?

"Bob Phillips" wrote:

You need some sort of data flag to say he/she no longer works here, and
to
test that in the formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bill R" wrote in message
...
I have a workbook that contains the sales information for all twelve
months
and YTD based on the current sales information. In this workbook I
also
have
a tracking report that projects statistics and sales gross for the end
of
each month and YTD that breaks down each salesperson's production
calculated
based on the current date.

Here is the problem: If one salesperson gets fired or quits how do I
keep
the formula from continuing to track His production based on what
He/She
had
done before He/She left? I would like it to add His total numbers but
not
continue to forcast add'l production. Any ideas?