Summry Total using VBA
I am aware that this can be achieved by PIVOT and by set of compex formulas.
I am just learning VBA and I thought that this can be a starter
"Greg Glynn" wrote:
Hi Anath,
This is a perfect set of data to use in a pivot-table, which will give
you the answers you need without requiring VBA.
Give it a try.
Highlight your data and click on: DATA/PIVOT TABLE/FINISH
Hope this helps
Greg
Ananth wrote:
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.
|