hello friends ,
this one little difficult to search and experiment for me .
so finally posting it for your help .
i have 3 sheets .
1 ) filter-order : which defines filter order .....
2 ) filter : this sheet defines TO and FROM to be filter .....
3 ) data : data to be filter , by taking instructions from filter data .....
sample excel i have attach , please check ,
in sheet "custom-order" there are 3 column in which filter order is given .
in sheet " filter" i want to filter all values coming in between AAA+ AND CCC+ ( values define in "CUSTOM.ORDER SHEET")
then all values coming in between VERY GOOD AND GOOD( values define in "CUSTOM.ORDER SHEET") , and finally all values coming in between 50 and 25( values define in "CUSTOM.ORDER SHEET")
.....but all this filter to be done in "DATA" sheet .
expected result i have filtered in data sheet..
if we change values in TO and FROM in filter sheet , it should filter according to that in data sheet.
Bookmarks