Monty
Well-Known Member
Hello Everyone.
This is regarding on the reconciliation file which have multiple condition to match...tried with looping through and auto filtering but no success.
I have data which comes from two different systems which we can not be change either helper columns or interchange columns to simplify it.
The data size would be around 50k...and taking 8 hrs to do the rec between two sheets.
So basically question is..Need to compare two sheets based on some parameters..
Attached file with complete notes.
Please do need full.
This is regarding on the reconciliation file which have multiple condition to match...tried with looping through and auto filtering but no success.
I have data which comes from two different systems which we can not be change either helper columns or interchange columns to simplify it.
The data size would be around 50k...and taking 8 hrs to do the rec between two sheets.
So basically question is..Need to compare two sheets based on some parameters..
Attached file with complete notes.
Please do need full.
Attachments
Last edited: