Comparing 2 tables with 3 column values and display the unmatched row in another sheet

[VbDom]

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!

 

[ER_Neha]

Hello, do you want to compare the two tables among themselves or with another three columns. It will be easier to provide you with the solution if you can provide a sample of your data using xl2bb

aslo among which three column you want to compare, please specify

 

[VbDom]

Hi @ER_Neha. Thanks for your reply. Below you can find the mini-sheet, that I have uploaded. Here I wanted to compare id, rating and work hours column between 2 tables. With these columns as condition I wanted to display the unmatching rows in the next sheet. For example, if we are starting from the table on the left side, the above mentioned 3 columns should be compared with the right side table and if any one of the values is found to be not matching it should be displayed on the next sheet.

test.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	ID	NAME	RATING	WRK_HOURS						RATING	ID	NAMES	WRK_HOURS
2	A-1	SANNAY	A	8						A	A-1	SANNAY	8
3	A-2	BINDO	B	8						B	A-2	BINDO	8
4	A-3	VINOD	A	8						A	A-3	VINOD	8
5	A-4	KUMAR	A	8						A	A-4	KUMAR	8
6	A-5	PAULL	B	8						B	A-5	PAULL	8
7	A-6	PETER	A	8						A	A-6	PETER	8
8	A-7	THOMP	C	8						C	A-7	THOMP	8
9	A-8	SAM	D	16						D	A-8	SAM	8
10	A-9	WILSON	A	8						A	A-10	KOOPER	8
11	A-10	KOOPER	A	8						A	A-11	VARUN	8
12	B-1	JASON	B	8						B	B-1	JASON	8
13	B-2	NELSON	A	4						A	B-2	NELSON	4
14	B-3	JAGDISH	C	8						C	B-3	JAGDISH	8
15	B-4	KUMAR	D	6						D	B-4	KUMAR	6
16	B-5	SHYAM	A	8						A	B-5	SHYAM	8
17	B-6	CHARLIE	D	8						D	B-6	CHARLIE	8
18	B-7	KISHORE	A	8						A	B-7	KISHORE	8
19	B-8	MASON	A	8						A	B-8	MASON	8
20	B-9	JOHN	B	8						B	B-9	JOHN	8
21	B-10	KIRAN	B	8						B	B-10	KIRAN	8
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:A	Cell Value	duplicates	text	NO