Mar 21 2023 01:39 PM
Hello,
I have an excel table that when a drop down item is changed I would like it to clear the notified column next to it. I am looking to complete this without any VBA codes. I need the document to auto-save, I have not found a way to auto-save it using macros.
Example above, if I change Pending parts to say sub-contractor, I would like it to clear the yes
Please help?
Mar 21 2023 02:21 PM
As far as I know, it is not possible to clear a cell when the value of another cell is changed without VBA code.
Mar 21 2023 03:09 PM
Mar 22 2023 06:16 AM
Mar 22 2023 08:09 AM
You could enter a formula in the next cell.