DYNAMIC CRITERIA RANGE WITH ADVANCED FILTER
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.
File attached for your reference.
Bookmarks