On my attached sheet, 'Totals' is to be a count of all the different vehicle types on the 'Type' sheet. When I am looking to have done is to have the count of the 'Type of Vehicle' in the 'Type' sheet placed into the appropriate cell on the 'Totals' sheet. For my example, on the 'Total's sheet, it should say: Cars - 3, Trucks 4. (this is a 1% sample of my data - my actual data is 90,000+ rows, with many different types of vehicles).
I know I can perform a sort/filter to get my totals, but wanted to see if I could get a macro or something to do it for me instead since the numbers are always changing. In addition, once you get me started with a macro, then I can add the other vehicle types.
Please advise with any questions.