software

Hello all again,

I have the following list in worksheet Project ListRow/ColA BC D

6
7Project # Project NameProject Category Owner

8001 Get T1 LineITRex
9002 New Logo design MarketingRudy
18011 Order LetterheadPurchasingHenry
35028 Set up ComputersITAlex
36Asterisk 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

AB C D E

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

I have set a data validation IN cell E1 TO quot;ownerquot; and in cell b5 to
quot;Project Categoryquot; 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?

ThanksOn Sun, 29 Jan 2006 16:50:27 -0800, rudawg
gt; wrote:

gt;Hello all again,
gt;
gt;I have the following list in worksheet Project List
gt;
gt;
gt;Row/ColA BC D
gt;
gt;6
gt;7Project # Project NameProject Category Owner
gt;
gt;8001 Get T1 LineITRex
gt;9002 New Logo design MarketingRudy
gt;18011 Order LetterheadPurchasingHenry
gt;35028 Set up ComputersITAlex
gt;36Asterisk Next new record
gt;37 ---Blank Row---
gt;38 END
gt;
gt;Each time a new Project is asssigned, it is added to this list.
gt;
gt;On another workseet called To Do List - by Owner, I am attempting to have
gt;this Project List filtered by owner and project category
gt;
gt;AB C D E
gt;
gt;1 To-do list To be completed by: quot;Ownerquot;
gt;2 Deadline:
gt;3
gt;4
gt;5Done?Project Cat Due By Notes
gt;6
gt;
gt;
gt;
gt;
gt;I have set a data validation IN cell E1 TO quot;ownerquot; and in cell b5 to
gt;quot;Project Categoryquot; When I select the Owner and Project Category in sheet To
gt;do List by Owner, I would like to see the original list from sheet Project
gt;list filtered to give me a to do list by owner and project category.
gt;
gt;
gt;Is this possibe?
gt;
gt;Thanks

Hi,

I'm not quite clear why you need data validation, nor even why you
need a second sheet since you can filter the Project List sheet in
place.

Make the data start at say row 5. Then with the cursor anywhere in the
data on Project Sheet choose Data Filter Autofilter and you'll find
that you get drop down arrows at the top of the column headings, Proj
#, Project Name etc.

Now just choose the owner and category you wish to see.

If you need the data filtered to a second sheet, then put the column
headings on the second sheet in say A11 and set a couple of criteria
cells in A1 and B1on the first sheet by entering quot;Owner' and 'Project
Category'

Then add a particular owner to A2 and Project category to B2 and
finally choose Data Filter Advanced Filter, selecting 'copy to another
location, choose the range you want to filter in 'List Range' and
A1:B2 as the Criteria Range, and A1: D1 as the Copy to: range then OK.

You could smarten this up by making A2 and B2 data validation cells
and selecting the list option for each one and then choosing the whole
list of names and categories for the validation. It would make sense
to take a unique list of the names and categories to a separate area
and use these in the data validation list. That way you'll only see
one occurrence of each name/category

Hope this helps

Rgds
Richard Buttrey
__