Filter my tabel's header accroding to when i type in a1, b1, c1, and d1 value

[HaroonSid]

hi, all of you

I want to filter my table according to the value of range A1, B1, C1 AND D1
when I type value in above cell then it filter my data with cell value

thanx

sample workbook attached

[Mumps1]

Place this macro in the worksheet code module:

Please Login or Register  to view this content.

[HaroonSid]

Thanx Mumps1

Will try in morning

[HaroonSid]

Thanx Mumps1

Will try in morning

[mike7952]

Another way

Please Login or Register  to view this content.

[HaroonSid]

Thanx for the reply both of you

here is a little issue
column d and column e is not going to filter

[HaroonSid]

Thanx for the reply both of you

here is a little issue
column d and column e is not going to filter

[HaroonSid]

Column d and e problem are solved
but
I have a issue in above code...

filter is working after type data in column a, b, or c.....

but i want to filter work as I type in cell,
for example
I type in a1 ....7 then it filter the 7 value with out making Enter or leave cell

And filter is not also working with two criteria
thanx