DYNAMIC CRITERIA RANGE WITH ADVANCED FILTER

[DILPREET SINGH]

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.




Untitled 1 - The one where I Need to filter out the result in Sheet 2
https://www.pastepic.xyz/image/LYh58

Untitled 2- - Sheet 1 criteria range which is a dynamic range and keeps on changing depending of description https://www.pastepic.xyz/image/LYk2C

Result- I need to filter values from Description sheet 1 and subsequently Criteria_T gets filtered and which should be the Criteria range for advanced filter and eventually the values shall get filtered in Sheet 1 Criteria_T