Hi Tricia,

Do you really want to use VBA or will a function suffice?
If so, use
=SUMIF("Your List Range Here","456897 Broom","Your Range to Sum")

HTH

FD

"Fiero84" wrote in message
...
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 :)