Dear jraj1106 :
i mean each Letter of Grade in column S2:S10000 ( A,B,C,D ext ... ) has a value in column T2:T10000 ( 95,90,85,80,ext ...) , so each cell in column S has value in adjacent cell in coulmn T ,( A=95,B=90,C=85,D=80,E=50 ext .... ) or lets say ( cell S2= value in cell T2 , and cell S3 = value in cell T3 and S4= value in cell T4 ,ext ... ), so when i type any Letter ,(lets say letter A ) in cell L1 the value i want to search in column E is 95 and Less , and if i type the letter C in cell L1 the value i want to search in column E is 85 and Less , then give result of all names in column B that has value in column E Less than value of cell L1 , and put the result in Column Q ,
also, i want when i press the command button the result start Q2 and P2, because i don't want duplicate the result if i press on command button twice ( 2 times ).
please send me the file with the code .
i'm very thankfull jarj1106 for your attention.