Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
Protecting a worksheet containing XML List | Excel Discussion (Misc queries) | |||
Can one print a list of worksheet tab labels contained in a workb. | Excel Discussion (Misc queries) | |||
List box not being displayed in second worksheet | Excel Discussion (Misc queries) | |||
Validation - List - Separate Worksheet | Excel Worksheet Functions |