how can filter data with condition.
i have data like this
A B C D
1 a 10
2 b 20
3 c 10
4 d 40
5 e 10

when I enter any nos in D1 cell, my sheet filter (advance filter) with
condition like d1
result
A B C D
1 a 10
3 c 10
5 e 10
like this

RKS