Forum Discussion
How to make a cell blank if another cell is changed?
i want to update the date of the latest CANS NY and the cell "✔" sould erase itself or change to "x"
The attached contains a code on Sheet1 Module for Sheet_Change and Sheet_SelectionChange Event.
Does this work for you?
Subodh_Tiwari_sktneerthank you all for trying to help me, I am going to explain my self again, I am sorry I guess I was unclear,
the CANS NY assessment is due every 6 month, then I have to upload the CANS NY assessment form to a site,
every time I make a new CANS NY assessment I change the date, but the check that i uploaded the last one is still there, and I can forget to upload the CANS NY assessment form.
So this is what i want:
when i change the date for the last CANS NY assessment I want the check on the uploaded row to become a X and i will change it manually to a ✔ when I will upload the CANS NY assessment form
