Auto Filter-Or any other suggestions

S

Sandie

I need to be able to sort the data on my worksheet by project so that it
brings up all of the associated items for that category. For example: If I
sort on Project #1, I would like for it to bring up all of the activities,
actions, and due dates only for that project. How would I do this if the
items in Activity, Action , and Due date are in different rows? When I try
to auto filter by Project, it only brings up Acitivty 1-1, Action 1-1, Due
date 1, but I need for it to bring up every Activity, Action, and Due date
for Project 1.

Any suggestion would be greatly appreciated!!

For Example:

Column A: Column B: Column C: Column D:

Project 1 Activity 1-1 Action 1-1
Due 09/14/04
Activity 1-2 Action 1-2
Due 12/01/04

Project 2 Activity 2-1 Action 2-1
Due 01/01/05
Activity 2-2 Action 2-2
Due 11/03/04
 
S

Sandie

Sorry...the data in Column D should be the Due date that you see under each
Project. Just came out kind of weird when I sent it.......Anyone?
 
S

swatsp0p

Auto filter will do exactly what you want. You just need to make sure your
data is in the proper format. Each row must have an entry in the "Project #"
column (col. A?)to identify it. Then when you select, say, Project 3, all
rows of data that relate to that project will be displayed. Even if some
cells are blank.

HTH

swatsp0p
 
Top