Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I'm not clear on what exactly your problem is. If you are trying to use a range from another workbook in a data validation list, try this: Here is an example of applying data validation between workbooks: 1. In the one workbook name the range containing the items you want listed, here I named it Months. (highlight the range and choose Insert, Name, Define, type Months into the Names in workbook box and click OK). 2. Move to the workbook where you want to display the list and choose Insert, Name, Define and in the Names in workbook box enter List. In the Refers to enter something of the form ='10-21-2008.xls'!Months 3. Select the range where you want the list and choose Data, Validation, List 4. In the Source box enter =List -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Jessica" wrote: Hi, I posted this over in Excel Links but I don't think it gets much traffic. I have book1 that has a query that brings down a list from access (name= Project). I need to use this list in a drop down box (validation). I also need to update the list periodically. The problem is that my users are opening the spreadsheet as a template and may need updates while using it. They do not have Access so they can't do the update. So, I wanted to create book1 with the list & query. Then have the template (book2) reference the list in book1. I tried: 1) doing a copy/paste/named range macro but that just seems like a workaround 2) creating a named range in book2 that references book1 but it only works when book1 is open. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel query and link named range | Links and Linking in Excel | |||
named range link | Excel Worksheet Functions | |||
named range and link | Excel Worksheet Functions | |||
Link to a named range in another worksheet that is sorted frequent | Excel Worksheet Functions | |||
External link to Named Range | Excel Discussion (Misc queries) |