Hi All,
I have been trying to complete a macro for long time now, with no luck. Would be really wonderful if someone can crack it. Heres what I am looking for -
A code to compare two sheets and validate if it is a Pass or a Fail.
"Account" on either of the sheet is the primary key. So step 1 is to check of the account column is the same.
If yes, then match other columns and even if one of the column doesnt match, then mark the last column as "Fail".
Should every detail match then mark as "Pass". Result can be in one of the two sheets.
There is one exception though,
Column "Lots" might have one row matched to many as there could be summation involved. For eg. Sum of 3 rows, on one sheet,
might add up to the one row on the other. Code should factor this in.
Also, some of the requirements are
1 Columns can be anywhere in both the spreadsheets - Hence it has to be dynamic
2 There can be multiple columns on the sheet and columns to compare are only listed in the sample sheet.
3 Data compare can be between numbers, date or text.
Thanks a lot in adavance.
Any questions or clarifications, please respond.
Cheers
K