MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
I'm working with excel vba macro, I was able to write some codes time to time by adapting already existing ones from the net or via macro recording.
This time I was not able to find a solution wandering through the net, I'll try to explain what I would like to achieve.
I have an excel sheet, clearly bigger, but more or less like the following (it is not a table neither a pivot table, it is just a worsheet filled with data):
|Country||Transaction ID (Approval Req # - NIPR #)||Tier||BU||Main BU||MCC||Rebate Amt||Partner TAT||Amt in USD*Partner TAT|
On the column headers I have an auto-filter, I would like to automatically filter each country, Tier and Partner TAT and take sum of Rebate Amt. It means I want to filter AU, T1 and 35 (Partner TAT) and sumup Rebate Amt, then filter KR, T1, 45 and sumup the rebate amt.. and so forth, everything automatically just by pressing a button.
I was not able to figure out how to automatically filter for all the available criteria in three columns.
The total number of countries is around 100 (by the way they can partially change every month), everyday I will have around 130 countries but they can be different from the previous day.
Total rebate amount should be entered in below Table (this is T1 table)
Hope I explained myself decently.
|T1||Target TAT||Rebate Paid in TAT|
Thank you so much