| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating dynamic chart from within VB6 | Charts and Charting in Excel | |||
| Creating a dynamic list based on a minimum common variable. | Excel Worksheet Functions | |||
| Looking for help creating dynamic list numbers | Excel Worksheet Functions | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
Linear Mode
