autofilter-v.urgent
 

Hi all

I have protect excel sheet. some column, user enter data and some have
formula where data comes automatically.

In SHEET 1 use enter data this ways
A B C D
Manager prodect sale date
XX AAA 500 01/01/08
XX BBB 600 01/01/08
....
YY AAA 300 05/01/08

I want to filter data in sheet 2 where condition on Manager, prodect and data
I want to use dropdown in sheet 2 and all data display which user are enter.
last row are not fix its depend user to fill data

Please help me urgentlly.
Thanks in advance
RKS