Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To add extra line/lines to single cell in Excel spreadsheet | New Users to Excel | |||
Inserting extra lines for comments in an excel sheet | Setting up and Configuration of Excel | |||
Excel v10. Extra lines printing to Text file | Excel Programming | |||
Delete extra rows at the end of macro run | Excel Programming | |||
Delete extra rows at the end of macro run | Excel Programming |