auto filter with condition

[Guest]

Hi anybody help me. i hv data. i can use auto filter
I want if i am enter any value in E1 (Marks), the auto filter automatic
reflict in Marks Column (C)

Row A B C D E ---------->Column
1 Sno Name Marks 50
2 1 aa 50
3 2 bb 66
4 3 cc 78
5 4 dd 49
6 5 ee 58
7 6 ff 35
8 7 gg 26
9 8 hh 50
10 9 ii 59
11 10 jj 60
12 11 kk 45
13 12 ll 50
14 13 mm 66
15 14 nn 78
16 15 oo 79
17 16 pp 35
18 17 qq 26
19 18 rr 59
20 19 ss 79

Output - which i want

When I am enter value in Marks(E1) =50 the its filter automatically this
type
Row A B C D E ---------->column
1 Sno Name Marks 50
2 1 aa 50
9 8 hh 50
13 12 ll 50

PL help me urgently
RKS

 

[Guest]

I can write a macro to do what you want. However I can't test on versions
prior to Excel 2002 (XP). It will run automatically each time the value
changes in cell E1. Let me know if that is what you want.

Very easy to install and I can provide instructions on how to install.
However, you will need to set options to allow macros to run. If not sure how
to do this then let me know what version of Excel you have.


Regards,

OssieMac