Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Interesting Workbook formula problem
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy formula from one workbook to another | Excel Discussion (Misc queries) | |||
formula Problem | Excel Discussion (Misc queries) | |||
Strange Formating problem with text and formula in same cell | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions |