Having a hidden little flaw in my Event code. Please have look at my workbook.

https://www.dropbox.com/s/pis3ctcd30...heet.xlsm?dl=0

Two sheets, with a drop down on Product sheet that refers to a named range, the range is on sheet Lot, column C (Dynamic).

The sheet Lot is the data sheet.

Select a item in the drop down and all "like" items are copied from Lot sheet to Product sheet, along with associated info.

Works almost as it should except if the item selected in the drop down is one that starts with "Talking". If code worked correctly there should be 4 "Talking" entries brought from Lot sheet to Product.

Instead, the entire list from Lot is copied to Product(minus the fourth Talking item). That should be some sort of clue, but does not register with me.

Select any other item and all those "like" items are copied correctly.

There are groups of Radio Controlled, Remote Controlled, Radio Button and the misbehaving group Talking Clock.

I'm probably looking right at it but I ain't seeing it.

Thanks,

Howard