• 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.

Get Data with filters

prsnthkrishna

New Member
Hi All,

I need small help. I want to get data by filtering from raw data. it consumes time for me. can anyone give vba code for this?

1. We should make few filters in columns like Tier, Country and TAT.
2. We need data in column N and column O. Data is available from column A - I.
3. column O contains sum of rebate amount by filtering only country.
4. column N contains sum of rebate amt by filtering country and TAT. TAT can be filtered as per column L (example: <=15 for AU or <=40 for ID)

I think we should keep many loops/array or if-conditions here to get these values. Can anyone help me with vba here..
 

Attachments

  • L1_APJ_Jun'20.xlsb
    412.4 KB · Views: 5
Your post has received 29 views and no answers.

It would appear your explanation is not sufficiently clear to the readers on the Forum. You might want to reword your goal.
Make the goal clear, simple and short ... so it is understandable.
 
Back
Top