Create Excel Macro to summarize spreadsheet

What I am looking for is to have a report that will show me by Vendor Name the total quantity ordered for each item. Currently the report is broken down by vendor, purchase order and then items placed under each p.o. So for example under the vendor Ash Pallets, I would like to see the total quantity ordered of item 40x48 # 2 pallet, and a total quantity ordered of the 40x24 # 2 pallet and so on. ## Deliverables Please make sure the solution is easy to use (as it won't be used by a technical person) AND that it is easy to reproduce for future monthly spreadsheets of the same layout.