| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i create a drop down list of items from a different file
I need to have a file that stores a list of projects. This file will be
updated on a regular basis. In another file I need to have that list populated into a drop down selection. When the user opens the file it should auto update any changes to the project list that is in the different file. I have tried to do it using data validation but it will only pull the values in if I have both files currently open. I would like to have the project list file closed on a network and have the other sheet still pull the info in. How can I get this to work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide previously used items from multiple drop lists | Excel Worksheet Functions | |||
| How can I create a drop down list from non-adjacent cells | Excel Discussion (Misc queries) | |||
| CREATE LIST OBJECT IN EXCEL | Excel Worksheet Functions | |||
| How do I create a combo drop down list in Excel? | Excel Worksheet Functions | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Threaded Mode
