Hello!
I am very new to Excel so please bear with me on explaining this.
I am trying to clear a cell based on the a change to another cell. I wish to do this for each cell. What I mean is, in column G I have dates. and I want to be able to clear that date anytime I input data into the adjacent cell.
For instance:
G25 has : 1/2/2022
I want that to clear whenever I put data in cell H:25
I would like this to happen for the rest of the columns.
Is there anyway I can do this?
I know many people have said use a VBA code but I haven't found any for my specific needs.
Thanks so much in advance. Sorry if this isn't clear.
I am very new to Excel so please bear with me on explaining this.
I am trying to clear a cell based on the a change to another cell. I wish to do this for each cell. What I mean is, in column G I have dates. and I want to be able to clear that date anytime I input data into the adjacent cell.
For instance:
G25 has : 1/2/2022
I want that to clear whenever I put data in cell H:25
I would like this to happen for the rest of the columns.
Is there anyway I can do this?
I know many people have said use a VBA code but I haven't found any for my specific needs.
Thanks so much in advance. Sorry if this isn't clear.