LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Indirect formula using Data Validation List of Worksheet Tabs Scott Excel Worksheet Functions 1 December 5th 05 02:59 PM
Protecting a worksheet containing XML List John Allison Excel Discussion (Misc queries) 0 November 10th 05 10:07 AM
Can one print a list of worksheet tab labels contained in a workb. Kelroy D B Excel Discussion (Misc queries) 1 January 27th 05 07:03 PM
List box not being displayed in second worksheet Brian Excel Discussion (Misc queries) 2 January 27th 05 04:35 PM
Validation - List - Separate Worksheet J. Osborne Excel Worksheet Functions 1 October 28th 04 04:23 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"