Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

ADVANCED FILTER WITH DYNAMIC CRITERIA RANGE

0

1. I have data in Sheet 1 having 2 columns name Description and Criteria_T and in Criteria_T "*" is used for advanced filtering criteria for text filter i.e. Criteria range

2. In sheet 2 I have "Criteria_T" Column Header which is having different data and needs to filtered using Criteria_T as "criteria range" which is dynamic as description data keeps on changing. 

Result: I need to filter data in sheet 2 under "Criteria_T" automatically "as I filter down values in description and Range_T(being the criteria Range) in Sheet 1 

Please help me out with vba code.

Thanks.

excelsort-filter
MS Office Version: Excel 2016
posted by: Dilmen on Thu Jan 17, 2019 at 4:58 am
Answer
Discuss

Discussion

You may not get the result you want because you succeed in telling how you want the solution to be achieved but fail in describing what the solution is. On the first count, "filtering" is a worksheet tool and not necessarily best applied by VBA. If you want a VBA solution don't insist on using filters. On the second count, how do you imagine the user would select "Criteria_T" and what would the result look like on Sheet2? (perhaps add a fourth sheet to show the filtered result.) Your use of the word "automatic" suggests a series of clicks which produce the result, meaning you imagine something you haven't explained.
However, sadly, after you fix all those problems with your question, no one will want to write the code for you. The "industry standard" is that you should show an effort, some feeble (at least) start of trying to reach a solution on your own.
Variatus (rep: 4889) Jan 18, '19 at 3:57 am
Add to Discussion

Answers

0

What if you make your ranges TABLES? Tables will automatically update range if you add info below them.

posted by: queue (rep: 467) on Thu Jan 17, 2019 at 8:34 am
Discuss

Discussion

Thanks for the reply. 

But the criteria range is not updating. 

If you could pls share your mail Id  I ll share the sheet for better understanding. 

Regards
Dilmen Jan 18, '19 at 12:23 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login