Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary using VBA
ORDER DATA
Order # Part# Qty 1 A11 3 2 A12 4 3 A11 1 4 A12 2 5 A11 3 6 A11 1 7 A11 2 8 A13 2 9 A11 3 10 A12 4 I have order Order #, Part # and Qty in Col A,B, C in Tab-A I want USING VBA a summary as under in TAb-2. I am aware this can achieved vy PIVOT, SUBTOTALS etc. ORDER SUMMARY Part# Qty A11 13 A12 10 A13 2 Grand Total 25 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary SUM | Excel Discussion (Misc queries) | |||
Summary | Excel Worksheet Functions | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Summary | Excel Worksheet Functions |