LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default Link to Access & Named Range

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel query and link named range Jessica Links and Linking in Excel 0 July 6th 09 09:10 PM
named range link na Excel Worksheet Functions 1 September 17th 08 06:21 PM
named range and link na Excel Worksheet Functions 1 September 16th 08 05:13 PM
Link to a named range in another worksheet that is sorted frequent ShortBlonde Excel Worksheet Functions 2 March 18th 08 03:32 PM
External link to Named Range Fleone Excel Discussion (Misc queries) 0 December 18th 07 08:52 PM


All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"