looking for macro to compare multiple data columns from two sheets and delete line items subtotal = zero

[lstokes]

I'm hoping someone might be able to provide me a macro to assist me with a reconciliation I need to complete daily and monthly.

I have data from two separate systems that I export daily. I put the information on two separate sheets in an excel workbook. I'm currently having to complete the reconciliation manually line item by line item to identify the reconciling items. This is very time consuming considering the amount of information. The number of columns are different for each report and the header names are also different. However I have three columns that can be used to identify a match. If anyone can help I would greatly appreciate it!

Matching Criteria
Sheet 1 Header	Sheet 2 Header	Data Match
ID	Identifier	Exact Match
Unit	Type	Match First 4 characters from left
Descrip	Cash Description	Match First 11 characters from left
Amount	Amount	Subtotal (if zero delete lines from both sheets)

<tbody>
</tbody>

Sample Data Sheet 1

ID	Invoice	Unit	Descrip	Amount
68750	12345	SE01a	150410521521234	12,081.72
69351	12346	SE01b	150424594782345	5,800.00
46752	12347	SE02a	150423591863456	280,645.00
65453	12348	SE02b	150403484084567	92,895.00
57854	12349	SE03	150410521755678	18,600.00

<tbody>
</tbody>

Sample Data Sheet 2

Identifier	Misc Data	Misc Data II	Invoice	Type	Cash Description	Amount
68749			12345	SE01	15041052152	12,082.72
69394			12346	SE01	15042459478	5,800.00
46778			12347	SE02	15042359186	280,645.00
65441			12348	SE02	15040348408	92,895.00

<tbody>
</tbody>

Desired Results Sheet 1 (only Reconciling items remain on sheet)

ID	Invoice	Unit	Descrip	Amount
68750	12345	SE01a	150410521521234	12,081.72
57811	12349	SE03	150410521755678	18,600.00

<tbody>
</tbody>

Desired Results Sheet 2 (only Reconciling items remain on sheet)

Identifier			Invoice	Type	Cash Description	Amount
68749			12345	SE01	15041052152	12,082.72

<tbody>
</tbody>

 

[lstokes]

I apologize this is my first post ever and I made a mistake in the sample data and was not sure how to fix it. Below is the correct data

Sample Data Sheet 1

ID Invoice Unit Descrip Amount
68750 12345 SE01a 150410521521234 12,081.72
69351 12346 SE01b 150424594782345 5,800.00
46752 12347 SE02a 150423591863456 280,645.00
65453 12348 SE02b 150403484084567 92,895.00
57854 12349 SE03 150410521755678 18,600.00

Sample Data Sheet 2
Identifier Invoice Type Cash Description Amount
68750 12345 SE01 15041052152 12,082.72
69351 12346 SE01 15042459478 5,800.00
46752 12347 SE02 15042359186 280,645.00
65453 12348 SE02 15040348408 92,895.00


Desired Result Sheet 1
ID Invoice Unit Descrip Amount
68750 12345 SE01a 150410521521234 12,081.72
57854 12349 SE03 150410521755678 18,600.00

Desired Result Sheet 2
Identifier Invoice Type Cash Description Amount
68750 12345 SE01 15041052152 12,082.72