Hi all. Happy New Year. I am new to this forum and not very skilled with VBA. I have a worksheet that is not very big. I need to search it and see if a specific value (for this example just use abc123) exists in column A. If this value exists and a value of 'census' exists in the row immediately below it, I want to delete the entire row that has 'census' in it.
So... if 'abc123' exists in column A and 'census' exists in the row right below it, delete the row with 'census' in it.
I am guessing a for - next loop and some if statements need to be involved but I am not sure how to set it up. I have spent some time on Google but have not found exactly what I need.
Thank you!!
Bookmarks