On Wednesday, November 18, 2015 at 9:44:29 AM UTC-8, Claus Busch wrote:
Hi Howard,


did you look for the improved workbook?


Hi Claus.

Yes, much closer. The groups seem to be working but don't want any subsets within the text.

The copies from Lot sheet to Product should look like the one in my linked workbook. Need ALL the text from C column cells when copied over to Product sheet.

Also need ALL C column entries in the drop down.

Matching the Left(xxx, 7) of the drop down and the C column cells seems to be a workable and again not looking for any subsets.

Howard