auto filter with condition

R

RKS

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
 
O

OssieMac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top