PDA

View Full Version : Compare Column Value copy cell



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