Vba to Filter data
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.
|