Merging Workbooks

[DB100]

Hi all

I have a workbook ( Master.xls ) which contains a list of parts i
column A

I reveive a new list of parts ( NewDoc.Xls ) once a month which ma
contain some of the parts on Master.xls and will contain some ne
ones.

I am looking for a way to add the Newdoc.xls to Master.xls but not t
include any parts that are duplicated, but to highlight them instead.

Not sure this is possible ?

Any ideas

Thanks

Davi

 

[JulieD]

Hi

it's worth having a read of Chip Pearson's site on duplicates for situations
like this
http://www.cpearson.com/excel/duplicat.htm

Cheers
julieD