I have two workbooks, one containing my master data (Filename: VPRS) with the sheet called "Pro" and the other with a list of entries to check (Filename: ANP) with the data in a sheet called "Sheet_CLEAR".
I basically want to search column 'A' in the "Sheet_CLEAR" sheet for any value in column 'F' of my "Pro" sheet and if found, then delete the entire row in the "Sheet_CLEAR" sheet. The data in the "Pro" sheet is actually formatted as a table (Table8) and the column header is "VRM / ID" if it is possible to use that instead of the column reference.
I have tried a variety of options found online but none seem to quite work for me.
Any help would be gratefully received.
I basically want to search column 'A' in the "Sheet_CLEAR" sheet for any value in column 'F' of my "Pro" sheet and if found, then delete the entire row in the "Sheet_CLEAR" sheet. The data in the "Pro" sheet is actually formatted as a table (Table8) and the column header is "VRM / ID" if it is possible to use that instead of the column reference.
I have tried a variety of options found online but none seem to quite work for me.
Any help would be gratefully received.