View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RKS RKS is offline
external usenet poster
 
Posts: 63
Default 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