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?