Macro that will sum values from column if rows meet certain criteria [better sumif]

[SorryForMyEnglish]

Hi,

I want to create a macro which will make new file that will contain data from other file. While my English is bad and I really can't explain what I want, I hope that this picture representation will show what I mean.

I have this file (NAZWA means NAME and Wartość means VALUE):

pottAQK.png

And after running the macro, I want to have this new file:

http://i.imgur.com/a96GKJ4.png

Thanks in advance for every response!


PS. SUMIF is not the way, as files are much, much bigger than those in example.

[TMS]

Use a Pivot Table. Should be very straightforward. Insert tab. Choose Pivot Table. NAZWA goes in the row header and Wartość goes in the values. Done.

Regards, TMS

[SorryForMyEnglish]

Thank you for very quick response! I have to admit, that I've never heard about pivot tables (I'm new to Excel), but this seems to be, in fact, solution to my problem.

Thank you again, kind man.

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.