Macros Needed to identify duplicate invoice numbers

Hi there,

My boss gave me a project and need to be done as soon as possible. Basically, i just need to join all of database and then identify duplicates and put them in another sheet in order to investigate if there are any double payments.

Duplicates can be:

- invoices with same vendor name having same or comparable amounts
- invoices with Invoice No. which match or closely match (in case we're mis-keying)

I've tried so many ways to find duplicates that fulfill the 2 conditions above, but still cannot make it done. i'm just wondering if someone can create a macro to help me out? I have no idea about macro but i think it's the fastest way to do.

Any helps are truly appreciated. Thank you in advance.