Pete
08-28-2008, 10:37 AM
See attached workbook
Hi Experts
Need a macro to automatically switch the value from yes to no in worksheet "Contributions" row K12:O12.....when the user enters into any one of the worksheet(s) "scenario 1 to 5".....the word Essential Position into cell c7....
So sequnce:
if the user enter Essential Position into cell c7 in Scenario 1 then the validation switch to Yes in row k12 worksheet "Contributions" and all other fields remain NO
if then the user switches by enter Essential Positon into cell c7 worksheet "Scenario 2" and now "Scenario 1" is not the Essential Position, then worksheet "Contributions" row L12 = Yes all others remain as NO...
Hi Experts
Need a macro to automatically switch the value from yes to no in worksheet "Contributions" row K12:O12.....when the user enters into any one of the worksheet(s) "scenario 1 to 5".....the word Essential Position into cell c7....
So sequnce:
if the user enter Essential Position into cell c7 in Scenario 1 then the validation switch to Yes in row k12 worksheet "Contributions" and all other fields remain NO
if then the user switches by enter Essential Positon into cell c7 worksheet "Scenario 2" and now "Scenario 1" is not the Essential Position, then worksheet "Contributions" row L12 = Yes all others remain as NO...