I am looking for VBA code that will:
Then Count by Product line so that I have one row per Product line with the count of items
As shown in the attached file.
The data is on the consolidated sheet, I then need to end up with the count [per Product Line] on the Summary Sheet.
I hope I have explained myself well enough for an expert to understand the requirement.