I'm wondering if it's possible to delete a cell if the cell below it contains a specific text.
For example, In cell A1 the value is Mark, cell A2 is James and cell A3 is ABC. The program will now delete James because the cell below contains ABC.
How do you do it in VBA?
Thanks in advance!
For example, In cell A1 the value is Mark, cell A2 is James and cell A3 is ABC. The program will now delete James because the cell below contains ABC.
How do you do it in VBA?
Thanks in advance!