FirewalkerZ5
New Member
- Joined
- May 14, 2023
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Using office 365.
Cell B3 has a dropdown with "Proposed" and Approved". Column "B" has calculations from another sheet, Data validation, calculated formulas and user data input.
Problem, When Cell B3 is changed from "Proposed" to "Approved" I would like to lock the current values into Column "B" and prevent them from changing.
One thing I have done is included an "IF" function on the other sheet that says if Cell C8 has a value, use that value, if not place this calculation into Cell B8. The issue I have is that when I put a value into cell C8 it duplicates the value into B8 because of where the value comes from. I need this to also be able to be turned off if put back to "Proposed".
I did find something similar in this video but not exactly what I am looking for.
Cell B3 has a dropdown with "Proposed" and Approved". Column "B" has calculations from another sheet, Data validation, calculated formulas and user data input.
Problem, When Cell B3 is changed from "Proposed" to "Approved" I would like to lock the current values into Column "B" and prevent them from changing.
One thing I have done is included an "IF" function on the other sheet that says if Cell C8 has a value, use that value, if not place this calculation into Cell B8. The issue I have is that when I put a value into cell C8 it duplicates the value into B8 because of where the value comes from. I need this to also be able to be turned off if put back to "Proposed".
I did find something similar in this video but not exactly what I am looking for.