Clear data in one cell if another is not empty

[wrybel]

Hi,

I have a table that has 2 columns with dates. I would like to have a macro that clears the date cell under certain conditions. So first I enter the date in column B, and if I enter the date in column C for project A, the cell with the date in column B should be clean (and still have the date format). And if I re-enter the date in column B for project A, the date in column C should be clean and still have the date format. The macro should work for every project in the table.

Thank you for your help.

[Akuini]

Try this:

Please Login or Register  to view this content.

But the code only deals with change in one cell at a time.
If you need it to handle changes in multiple cells at once, like when you copy and paste multiple cells into the range, then you need another code. Let me know if this is the case.

[wrybel]

Thanks for your help ! Works well

[Akuini]

You're welcome, glad to help, & thanks for the feedback.