| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summry Total using VBA
I have a list of cars in Stockyards A1,A2, A3
Col A €“ Make, Col B Qty in Nos, Col C - Stockyard Honda 2 A1 Toyota 1 A1 Land Rover 3 A2 Ford 6 A2 BMW 2 A3 Mercedes 1 A2 Honda 2 A3 BMW 1 A3 Ford 5 A2 Toyota 3 A1 Using VBA I would like to see a summary of Cars Stock, that should look as under : BMW 3 Ford 11 Honda 4 Land Rover 3 Mercedes 1 Toyota 4 Grand Total 26 Any help will be greatly appreciated. I would extend the logic for 25 Models of cars spread across 120 Stock yards. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Threaded Mode
