VBA code for finding out duplicates from multiple sheets

[prashanthng]

Hello

Need help in finding duplicate document no & Vendor name & value from a multiple sheets. Attached sample sheet.

rgds
Prashanth

[ranman256]

Attach the worksheet to access as a table
start the query wizard and choose: FIND DUPLICATES QUERY WIZARD

[prashanthng]

can any advice how to move the thread to VBA & other help. The data is in exel

[ranman256]

Yes, it works for excel, but if you dont have Access, then you are in the wrong thread.
(tho, you could enumerate the lines, then run Excel's remove duplicates function)