Jul 28 2021 10:18 AM
i want to update the date of the latest CANS NY and the cell "✔" sould erase itself or change to "x"
Jul 28 2021 11:31 AM
If date then hack, otherwise X.
Example in the inserted file.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Jul 28 2021 12:30 PM
@NikolinoDE I want when I change the date to a "new date" it should lose the check,
The change in cell C2 should be the trigger to change or erase cell C3,
Jul 28 2021 12:36 PM
Jul 28 2021 11:36 PM
Jul 29 2021 12:31 AM
The attached contains a code on Sheet1 Module for Sheet_Change and Sheet_SelectionChange Event.
Does this work for you?
Jul 29 2021 06:31 AM
@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