Run reports in Excel for product sold, like:
456897 Brooms 5
456897 Brooms 2
456897 Brooms 12

567890 Dust Pans 6
567890 Dust Pans 3
567890 Dust Pans 4
567890 Dust Pans 5

But, only need a summary, like:

456897 Brooms 19

567890 Dust Pans 18

Number of entries varies for each product, but identical items are listed in
a group.

Any Macro Gods out there?

I'd really appreciate it!!! Thanks!!! Tricia :)