I have seen numerous threads that touch on this topic, but can't find the exact code or figure out how to modify to work in my case.
I have 2 tabs (A & B)
I want to enter a value in tab A and delete the row in tab B that contains that value.
For example, if I enter a VIN number in tab A, I want it to search column A in tab B to delete the entire row of the match. There does not need to be any loops, as there will always only be one match.
Thanks in advance
I have 2 tabs (A & B)
I want to enter a value in tab A and delete the row in tab B that contains that value.
For example, if I enter a VIN number in tab A, I want it to search column A in tab B to delete the entire row of the match. There does not need to be any loops, as there will always only be one match.
Thanks in advance