Creating a dynamic list
 

Thanks in advance for your help.

What I want to do is have a list of completed projects that have date,
project number and description. In my mind this would be a separate
sheet. On a summary sheet, list the completed projects for that day.
It would look like the following:

Completed Project Sheet:

Date Proj. Numb. Description
1/6/2004 123 Proj 1
1/6/2004 125 Proj 2
1/7/2004 130 Proj 4
1/7/2004 132 Proj 5
1/7/2004 135 Proj 6

Summary Sheet
Report Date: 1/7/2004

Proj. Numb. Description
130 Proj 4
131 Proj 5
132 Proj 6

How can I do this? I have tried vlookup and could not make it work.
Thanks again for your help.

John

Creating a dynamic list
 

If I understand you correct then

Why don't you filter the project sheet on a date?

This is a good start
http://www.contextures.com/xlautofilter01.html


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"John N." wrote in message om...
Thanks in advance for your help.

What I want to do is have a list of completed projects that have date,
project number and description. In my mind this would be a separate
sheet. On a summary sheet, list the completed projects for that day.
It would look like the following:

Completed Project Sheet:

Date Proj. Numb. Description
1/6/2004 123 Proj 1
1/6/2004 125 Proj 2
1/7/2004 130 Proj 4
1/7/2004 132 Proj 5
1/7/2004 135 Proj 6

Summary Sheet
Report Date: 1/7/2004

Proj. Numb. Description
130 Proj 4
131 Proj 5
132 Proj 6

How can I do this? I have tried vlookup and could not make it work.
Thanks again for your help.

John