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