VBA to loop among filter criteria

[prsnthkrishna]

Hello,

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
KR	KR76REA200515_0012	T1	PSG	PPS	27R	1,654.28	45​	74,443
KR	KR76REA200519_0008	T2	PSG	PPS	27R	17,124.39	33​	565,105
AU	KR76REA200522_0001	T1	IPG	PPS	77R	4,955.48	35​	173,442
AU	KR76REA200522_0036	T2	IPG	PPS	77R	1,453.96	23​	33,441
AU	KR76REA200528_0002	T1	IPG	PPS	77R	25,080.78	19​	476,535
KR	KR76REA200528_0003	T2	IPG	PPS	77R	14,959.61	19​	284,233
HK	KR76REA200528_0007	T2	IPG	PPS	77R	35,181.74	19​	668,453
HK	KR76REA200528_0010	T1	PSG	PPS	77R	9,964.86	33​	328,840
KR	KR76REA200528_0011	T2	PSG	PPS	77R	18,330.37	33​	604,902

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
AU	15
NZ	15
ID	35
KR	35
SEMC	35
MY	35

Thank you so much

Prashanth Krishna

 

[prsnthkrishna]

Hi Guys,

Any update on this?

Waiting for reply..

Thanks.

 

[Fluff]

Cross posted multiple sites.

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all other sites where you have asked this question.

 

[prsnthkrishna]

Cross posted multiple sites.

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all other sites where you have asked this question.

If I get the exact answer, I will immediately update in other sites.

I still didn't get answer for this. Can you help here..

 

[Fluff]

Please supply links to all other sites where you have asked this question.
Thanks

 

[prsnthkrishna]

Please find the result for this request in below link..

Filter country column using loops and sumup amount in vba - OzGrid Free Excel/VBA Help Forum

[xpost] [/xpost] Hello, 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…

www.ozgrid.com

 

[Fluff]

I asked for ALL links, not just one of them.

 

[prsnthkrishna]

Please supply links to all other sites where you have asked this question.
Thanks

Yeah.. it's done..

 

[Fluff]

No it is not done. You have asked this question on more than one other site.
You must supply links to ALL other sites.