Comparing columns in 2 Excel files(workbooks)

[Guest]

I work for a financial firm. Every morning I compare today's cash balance
file (sent from our custodian) with yesterday's to see if there is anything
different in each portfolio cash balance column. Right now I'm doing it
manually checking row by row. It'll become tedious if more and more
portfolios are added. I'm looking for an efficient way I can use the
portfolio codes column (as a key) to compare with previous day's file's
portfolio codes column , and list only those portfolios(in a nother workbook)
if the corresponding cash balance column doesn't match.I think VBlookup is
limited. I need advice as how to approach this...thx

 

[Norman Jones]

Hi Schellam,

See Chip Pearson's duplicate page for a varirty of techniques:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

See particularly the sections, at the foot of the page, entitled:

Extracting Values Common To Two Lists

and

Extracting Values On One List And Not Another