ExcelBanter - Filterered list to new worksheet

On Sun, 29 Jan 2006 16:50:27 -0800, rudawg
wrote:

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

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 A1:D1 and set a couple of criteria
cells in A1 and B1on the first sheet by entering "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
__