How to sum and group macro?

[AccountingJ]

Hello

There is a macro in book2 that was done by someone in this forum, I posted a test version of my book thinking I could simply just paste it over on my book and it should work but it doesn’t.

As you can see column “X” in my Test2 workbook has a lot of blanks, I’m currently working on the order. Basically I’d like for the amounts in column “C” to be added and put them in number order in the tab named “Statements”. Like the macro in book2. Other possible issue that I see is that I want the names in column “Y” to be returned, not those in column “AA” that the Vlookup in column “E” brings over…