Hi Howard,

Am Wed, 18 Nov 2015 09:59:02 -0800 (PST) schrieb L. Howard:

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.

please have another look in OneDrive


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional