Hey Team,
I am trying to change a cell value based on the value of a drop down. For this example it essentially building Microsoft project functionality into Excel.
If drop down is set to Manual, start date is manually input.
If drop down is set to Auto, then a formula populates in cell to calculate start date.
So, each time you select a different value in the drop down it would need to either delete the formula and leave blank if Manual is selected or delete the value and add the formula is Auto is select. Maybe a macro is needed?
Thanks,
I am trying to change a cell value based on the value of a drop down. For this example it essentially building Microsoft project functionality into Excel.
If drop down is set to Manual, start date is manually input.
If drop down is set to Auto, then a formula populates in cell to calculate start date.
So, each time you select a different value in the drop down it would need to either delete the formula and leave blank if Manual is selected or delete the value and add the formula is Auto is select. Maybe a macro is needed?
Thanks,