Macro for Excel to add up items and delete extra lines?
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 :) |
Macro for Excel to add up items and delete extra lines?
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 :) |
All times are GMT +1. The time now is 04:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com