• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA loops using filters

prsnthkrishna

New Member
Please remember to follow all forum rules: Cross-posting
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):

CountryTransaction ID (Approval Req # - NIPR #)TierBUMain BUMCCRebate AmtPartner TATAmt in USD*Partner TAT
KRKR76REA200515_0012T1PSGPPS27R1,654.284574,443
KRKR76REA200519_0008T2PSGPPS27R17,124.3933565,105
AUKR76REA200522_0001T1IPGPPS77R4,955.4835173,442
AUKR76REA200522_0036T2IPGPPS77R1,453.962333,441
AUKR76REA200528_0002T1IPGPPS77R25,080.7819476,535
KRKR76REA200528_0003T2IPGPPS77R14,959.6119284,233
HKKR76REA200528_0007T2IPGPPS77R35,181.7419668,453
HKKR76REA200528_0010T1PSGPPS77R9,964.8633328,840
KRKR76REA200528_0011T2PSGPPS77R18,330.3733604,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.


T1Target TATRebate Paid in TAT
AU15
NZ15
ID35
KR35
SEMC35
MY35

Thank you so much :)

Prashanth Krishna
 
prsnthkrishna
Is this almost same as Your previous thread?
as well as

and with Your the newest
there is no sample file.

Please, reread Forum Rules
How to get the Best Results at Chandoo.org
 
Hi, The sample data is in body of email.

First table is in Sheet1 and second table is in Sheet2.

Let me know if you need anything else.
 
prsnthkrishna
Did You notice that I asked very basic question?
( that line above the first link is a question ... question > answer )

Did You reread Forum Rules as I give a hint?
 
prsnthkrishna
Did You notice that I asked very basic question?
( that line above the first link is a question ... question > answer )

Did You reread Forum Rules as I give a hint?

The question is not same.. but similar. The first question was in same sheet. Next question is in different sheet.. that is the only difference.

Thanks.
 
prsnthkrishna
Every other Forum too has basic same rules with cross-posting.
Seems that You have skipped all of those for some reason.

I've already asked You to reread this Forum's Rules.
Please do it
and
after that follow those rules.
 
Back
Top