I need to spend some time to digest this, but Product needs to be in quotes in this line of your code.

         If c.GroupName = Product Then
I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors. If Option Explicit were used in this code, it would have flagged Product as an undeclared variable.

It would really make this faster if I had your file.