J
John N.
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
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