Need help writing macro to replace one cell based on contents of adjacent cell

I am trying to write a macro that performs the following:

For each cell in Column A that contains "X"
If the adjacent cell in Column B contains "Y"
Delete contents of cell from Col A (or replace with blank)

How would I do this?

Hello there,


To begin press Alt+F8 on your keyboard to bring up the macro window. Clear the contents in the macro name and then type ClearX. Select the Create option.

In between the Sub ClearX() and End Sub copy and paste the below code

Please Login or Register  to view this content.

Close out of the visual basic window. Then press Alt+F8 again this time select the ClearX macro and select run.

Let me know if this works for you!

Thanks!

Works perfectly, thank you so much!

Glad to help! Don't forget to mark this thread solved and maybe give a little star tap if I helped!

Thanks!