Comparing 2 datasets with matching items

[nevillestoke]

I have searched the Board for something similar, but with no luck. I have two sets of data from different sources, but with matching fields. I need to compare the lists each month in order to match items for my bank reconciliation. I can do this by sorting and using the "Exact" function, but this is quite cumbersome contains more than 7,000 records per month. I think VBA code should be able to accomplish this quite quickly, but I have not found anything to work. I am uploading the sample data (which has been modified to remove names), and the items I am trying to match would be the Date, Customer Number and Amount. If there are items that do not match these three elements, the details should be reported on a separate tab. In the sample data, the first data set is column A to P and the second set is column R to Y. One example of a "non-match" would be the data in Row 8.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	BANK	SERIAL	LINE	TRANSTYPE	TYPE	IDREMIT	DATEREMIT	BTCHNBR	ENTRYNBR	POSTSEQ	REFERENCE	PAYORID	PAYORNAME	SRCEAMOUNT	PAYMCODE	SRCEDOCNUM	*	Currency	TransactionDate	OrderID	CustomerID	EchoData	CardType	TransactionCode	Amount
2	CIBC * *	1	1	2	5	122718	20160401	1	1	1	16805	49325	Customer 1	* * * * * * *134.30	VI * * * * *	PP000001 * * * * * * *	*	CAD	2016-04-01 0:00:00	470251	49325	[49325] John Q. Customer	V	27	* *134.30
3	CIBC * *	1	2	2	5	122732	20160401	1	2	1	1970	57727	Customer 2	* * * * * * * *72.26	MC * * * * *	PP000002 * * * * * * *	*	CAD	2016-04-01 1:10:00	470252	57727	Customer 57727	M	27	* * *72.26
4	CIBC * *	1	3	2	5	122733	20160401	1	3	1	78317	48820	Customer 3	* * * * * * * *99.32	VI * * * * *	PP000003 * * * * * * *	*	CAD	2016-04-01 5:29:00	470253	48820	Customer 48820	V	27	* * *99.32
5	CIBC * *	1	4	2	5	122734	20160401	1	4	1	20679	57793	Customer 4	* * * * * * * *72.26	VI * * * * *	PP000004 * * * * * * *	*	CAD	2016-04-01 5:34:00	470405	57793	Customer 57793	V	27	* * *72.26
6	CIBC * *	1	5	2	5	122735	20160401	1	5	1	95311	60399	Customer 5	* * * * * * * *72.26	VI * * * * *	PP000005 * * * * * * *	*	CAD	2016-04-01 6:23:00	470406	60399	Customer 60399	V	27	* * *72.26
7	CIBC * *	1	6	2	5	122736	20160401	1	6	1	489700	57218	Customer 6	* * * * * * * *72.26	VI * * * * *	PP000006 * * * * * * *	*	CAD	2016-04-01 6:29:00	470407	57218	Customer 57218	V	27	* * *72.26
8	CIBC * *	1	7	2	5	122737	20160401	1	7	1	63220	35618	Customer 7	* * * * * * *132.09	MC * * * * *	PP000007 * * * * * * *	*	CAD	2016-04-01 6:32:00	470408	51281	Customer 51281	V	27	* * *68.95
9	CIBC * *	1	8	2	5	122738	20160401	1	8	1	04897Z * * * * * * * * * * * * * * * * * * * * * * * * * * *	14691	Customer 8	* * * * * * * *72.26	MC * * * * *	PP000008 * * * * * * *	*	CAD	2016-04-01 6:38:00	470409	14691	Customer 14691	M	27	* * *72.26
10	CIBC * *	1	9	2	5	122739	20160401	1	9	1	08046Z * * * * * * * * * * * * * * * * * * * * * * * * * * *	47919	Customer 9	* * * * * * * *72.26	MC * * * * *	PP000009 * * * * * * *	*	CAD	2016-04-01 6:39:00	470410	47919	Customer 47919	M	27	* * *72.26
11	CIBC * *	1	10	2	5	122740	20160401	1	10	1	70375	53630	Customer 10	* * * * * * * *72.26	VI * * * * *	PP000010 * * * * * * *	*	CAD	2016-04-01 6:42:00	470411	53630	Customer 53630	V	27	* * *72.26
12	CIBC * *	1	11	2	5	122741	20160401	1	11	1	22635	53424	Customer 11	* * * * * * * *99.32	VI * * * * *	PP000011 * * * * * * *	*	CAD	2016-04-01 6:44:00	470412	53424	Customer 53424	V	27	* * *99.32
13	CIBC * *	1	103	2	5	122980	20160401	1	103	1	01269Z * * * * * * * * * * * * * * * * * * * * * * * * * * *	45241	Customer 250	* * * * * * * *57.59	MC * * * * *	PP000103 * * * * * * *	*	CAD	2016-04-01 13:47:00	470523	45241	Customer 45241	M	27	* * *57.59
14	CIBC * *	1	104	2	5	122981	20160401	1	104	1	401546	59704	Customer 251	* * * * * * * *67.15	VI * * * * *	PP000104 * * * * * * *	*	CAD	2016-04-01 13:47:00	470525	59704	Customer 59704	V	27	* * *67.15
15	CIBC * *	1	105	2	5	122982	20160401	1	105	1	412227	51436	Customer 252	* * * * * * * *72.26	VI * * * * *	PP000105 * * * * * * *	*	CAD	2016-04-01 13:54:00	470441	51436	Customer 51436	V	27	* * *72.26
16	CIBC * *	1	106	2	5	122983	20160401	1	106	1	79475	60894	Customer 253	* * * * * * * *72.26	MC * * * * *	PP000106 * * * * * * *	*	CAD	2016-04-01 13:59:00	470527	60894	Customer 60894	M	27	* * *72.26
17	CIBC * *	1	107	2	5	122984	20160401	1	107	1	427635	32506	Customer 254	* * * * * * * *72.26	VI * * * * *	PP000107 * * * * * * *	*	CAD	2016-04-01 14:04:00	470529	32506	Customer 32506	V	27	* * *72.26
18	CIBC * *	1	108	2	5	122985	20160401	1	108	1	87447	60895	Customer 255	* * * * * * * *67.26	VI * * * * *	PP000108 * * * * * * *	*	CAD	2016-04-01 14:06:00	470530	60895	Customer 60895	V	27	* * *67.26
19	CIBC * *	2	81	2	5	123150	20160402	2	81	2	11421	60925	Customer 395	* * * * * * * *54.31	VI * * * * *	PP000245 * * * * * * *	*	*	*	*	*	*	*	*	*
20	CIBC * *	2	82	2	5	123151	20160402	2	82	2	11484	60925	Customer 396	* * * * * * * *54.31	VI * * * * *	PP000246 * * * * * * *	*	*	*	*	*	*	*	*	*
SAMPLE