Compare Two Sheets and match

Hi,

I have a below code which matches the check number and amount with two sheets. But sometimes there will be duplicate check numbers and amount in both the sheets, due to this the code ignores to match. Can anyone help me to sort this issue.

Please Login or Register  to view this content.

If you want fix your code then

Please Login or Register  to view this content.

This should be much faster

Please Login or Register  to view this content.

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.

Hi Jindon,

Thanks, Your second code is really much faster. I will go with your code. Sorry I forgot to mention earlier, could you please add hyperlink in Column J in both the sheets that highlight the matched row until until Column H.

Can you do some adjustments in your code as below

Criteria 1. Find Check number and Amount (Code already provided by You) (Remarks - Check Matched)
Criteria 2. Find Amount which matches in both sheets where there is no check number or ignore check number (Remarks - Matched Amount)
Criteria 3. Rest all mark as Unreconciled (Remarks - Unreconciled)

1) Hyperlink to which one? you might have many to many relation.
2) Don't understand Criteria 2.

If you upload a workbook with much less data sets and the result clearly showing the logic will help to understand.

Hi,

I have attached the file with less data and showing the hyperlink in both the sheets.

Criteria 2 - After running the first Criteria Filter Remarks Column in both Sheets where there is blank and match the amount in both the sheets.
Criteria 3 - After running Criteria 1 & Criteria 2 Filter Remark Column in both the Sheets where there is blank and enter the value Unreconciled.

See if this works.

Please Login or Register  to view this content.

Hi,

Thanks, I have update my file but some lines it is giving wrong match in (Amount Only), if you check the hyperlink it takes to (Matched Both). Please see the highlighted rows.

And please Resize(, 8).Address for the hyperlink.

Try replace "MatchAndHyperlinks" with below

Please Login or Register  to view this content.

Thank you, for your excellent work. How can I resize the hyperlink address to select the row from A:H

Please Login or Register  to view this content.

Originally Posted by jindon

Please Login or Register  to view this content.

Excellent, Thank you Jindon for your worderful code.