Hi Guys,



Hope you all are doing good.

I have attached an excel sheet. In column A you will find a code. In one cell there are 3 codes. Important part of that code is first 6 charaters. Last 10 characters is always a date. you can ignore that.
In "sheet2" i have given 2 filter criteria( Validation in cell B2 and C2). I want to create a vbz code in such a way that what ever selection i will do in sheet2, that should act as a filter criteria in sheet1 in reverse order.

For example:
If i go to sheet2 and select "ES" in B2 and ":07:" in C2 then, all rows in Sheet1 where ever "ES:07:" is mentioned should be deselected.

I would be glad if anyone assist me whith any such code. Thanks.

Attached Files

Book3.xlsx (10.1 KB, 18 views)