Match codes from file

Hi Pugg,

Take a look at the "Test Worksheet" sheet in the attached workbook and see if it correctly identifies all of the "SWEEP" situations for Week 17.

If it does, we can then look at what's involved in copying those data to the "Master Code List" worksheet.

Use the "Check Products" button to perform the checks. When the "Product by Product" checkbox is ticked the routines perform the checks for a single product and then pause so that the results of those specific checks can be examined.

Hope we're making progress.

Regards,

Greg M