Hi everyone,
I'm having two tables in sheet1. One table is from Column A to G and another table is from Column M to Q. So, I have to compare both the tables, with 3 columns values as condition and if doesn't matches with any of the 3 values entire row should copied on to the next sheet. Is there anyway to achieve this using VBA code. Please let me know. Any help would be grateful!
I'm having two tables in sheet1. One table is from Column A to G and another table is from Column M to Q. So, I have to compare both the tables, with 3 columns values as condition and if doesn't matches with any of the 3 values entire row should copied on to the next sheet. Is there anyway to achieve this using VBA code. Please let me know. Any help would be grateful!