| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup to create a list from a larger list
I have a report with all our active projects that I can export into Excel.
The project number is in column A and the Project Manager is in column F, what I would like to do on another worksheet is list one project manager and all his projects. As the original report is in project number order, one project manager is scattered through out the report, can I create a list of one manger's projects on another sheet without the blank lines in between each project and without having to sort...so my results looks like the following?? A(PM) B(Proj #) Joe Smith 65485 66895 72589 89542 I would like one worksheet for each Manager without having to recreate each week Thank you very much, Terri |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create summarized list from larger list | Excel Discussion (Misc queries) | |||
| Automatically Deleting a List from Another (Larger) List | Excel Discussion (Misc queries) | |||
| Producing an automated list from a larger list | Excel Worksheet Functions | |||
| Pulling a Summary List from a Larger List | Excel Discussion (Misc queries) | |||
| Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions | |||
Threaded Mode
