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
Bookmarks