Discussion Locked

Macro- add up items then delete lines

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Everyday I run reports, in Excel, with multiple entries "SOLD", of the same product:
234345 Broom 5
234345 Broom 15
234345 Broom 20

234344 Dust Pan 15
234344 Dust Pan 2
234344 Dust Pan 30 etc...

When all I need it to say is:

234345 Broom 40

234344 Dust Pan 47

I have a macro that adds a blank line between DIFFERENT products. (Thanks to you guys!)

Now - I need to end up with ONE product description with a total sold. Then I'd like it to skip to the next product and do the same thing, total them up and delete the extra lines. The number of lines differs for every product sold.

Any Macro Gods out there? Thanks!!! Tricia :)

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.