Comparing data in two excel workbooks and creating a new file removing duplicates.

[andy.bentley]

Hi,

Have been asked by a friend to look at this and I’m struggling. They have an 'invoice statement' with invoice numbers (column A) and a 'invoice paid' again with invoice numbers (column B). I want to have a separate workbook 'Statement II' which will be an update on 'invoice statement' but with rows removed where they appear in 'invoice paid'.

Is this a case of using a macro or is there any other simple way?

Thanks in advance.

[jraj1106]

Hi

Upload sample files

[Climaxgp]

See attached workbook

[andy.bentley]

Hi jraj1106

I have attached the two excel files i'm working with.

Thanks again for your help.