View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rudawg
 
Posts: n/a
Default Filterered list to new worksheet

Hello all again,

I have the following list in worksheet Project List


Row/Col A B C D

6
7 Project # Project Name Project Category Owner

8 001 Get T1 Line IT Rex
9 002 New Logo design Marketing Rudy
18 011 Order Letterhead Purchasing Henry
35 028 Set up Computers IT Alex
36 Asterisk Next new record
37 ---Blank Row---
38 END

Each time a new Project is asssigned, it is added to this list.

On another workseet called To Do List - by Owner, I am attempting to have
this Project List filtered by owner and project category

A B C D E

1 To-do list To be completed by: "Owner"
2 Deadline:
3
4
5 Done? Project Cat Due By Notes
6




I have set a data validation IN cell E1 TO "owner" and in cell b5 to
"Project Category" When I select the Owner and Project Category in sheet To
do List by Owner, I would like to see the original list from sheet Project
list filtered to give me a to do list by owner and project category.


Is this possibe?

Thanks