Compare Price List

hi hecgroups, please check attachment, press "Find Duplicates" button

Notes:

The code does the following actions:
1. Looks for duplicates in Old List data. Duplicate is a simultaneous repeat of Service Code, Service Description and Price more than once
2. Looks for duplicates in New List data. Duplicate is simultaneous repeat of Service Code, Service Description and Price more than once
3. Looks for duplicates in both sheets provided duplicate means simultaneous repeat of Service Code, Service Description and Price exists more than once in the other sheet

For Old and New lists, the duplicate rows are separated by coma if multiple instances found. When comparing sheets and duplicate is found, the row number from Old list is followed by coma, row numbers (if multiple) are joined by &.

The code does not have % of completion feature (I treat as fancy so I never use it).