How to clear the contents of a cell, based on the content of an adjacent cell

[duncanjosh]

Hello Forum,

I am trying to conditionally clear the content of cells, based on the content of an adjacent cell. I attached the spreadsheet with the code I have so far. Here is the VBA code:

Please Login or Register  to view this content.

In the attached file, I have managed to clear the contents of cell F7 if the content of E7 is "Major". I would like to continue that for all cells below row 7 in those columns. However, as someone who does not know what they are doing, I am stuck. Can anyone help?

Thanks!

[nilem]

Hi duncanjosh,
try it

Please Login or Register  to view this content.

[duncanjosh]

It worked beautifully! Thank you nilem.