tlchan
04-07-2012, 07:43 PM
Hi there,
My objective is to show variances in the balances for 2 months report eg Jan vs Feb where Column A of sheets "Data Jan" and "Data Feb" contain unique ID for each client but not in the same order.
The result is to show in sheets "Variance Report". New ID which not match will also to be include in the report(shown in blue text).
How should accomplish this with VBA?
Sample workbook attached :dunno
Thank you
My objective is to show variances in the balances for 2 months report eg Jan vs Feb where Column A of sheets "Data Jan" and "Data Feb" contain unique ID for each client but not in the same order.
The result is to show in sheets "Variance Report". New ID which not match will also to be include in the report(shown in blue text).
How should accomplish this with VBA?
Sample workbook attached :dunno
Thank you