Car Manufacturer Auto Filter Macro Problem

Hey Guys,

I'm sitting here at work and due to my very limited VBA knowledge i cannot seem to solve the following problem:

I'm in the purchasing department of a car manufacturer, were buying different parts from different suppliers, from most suppliers we buy more than one part. This is represented in a list: every part we buy is a row which contains the information of which supplier we buy it and what the turnover for that part is.

Now i select a supplier by autofilter, so the table shows all parts that are bought from this supplier and the corresponding turnovers. Underneath the all the different turnovers, i calculate the sum via Subtotals(9,...).

What i need now is a macro, which writes the name of the supplier i select by filter and the calculated sum of the turnovers of all parts that are bought from this supplier in another sheet, and does so for every supplier that's selectable in the filter if possible. The purpose is that i can see with which of the suppliers our company has the biggest turnovers with, so i can make a ranking which ones are the most important.

I hope you got what I want to do, I'd greatly appreciate your help!

P.s.: I'm sorry i don't attach any files, but some of the data should not be accessible to the public.

Hi,
I think a sample file would help. Before making it public you may replace the original names and item names to meaningless words, and of course reduce the whole to a smaller number of rows and columns.
I write because I don't comletely understand the task.

Kaus Borealis

Thank you two for responding, a pivot table was exactly what i needed, i had never used it before.