+ Reply to Thread
Results 1 to 4 of 4

Linking Data Validation Lists to a Workbook

  1. #1
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    127

    Linking Data Validation Lists to a Workbook

    Hi,

    I have a question regarding linking the content for data validation lists stored in a different workbook.

    The scenario is as follows:
    I will have say 50 users using a template which contains various dependent drop-down lists. These lists work by using the INDIRECT function which calls the
    correct drop-down based on the previous selection. The drop-down entries are currently stored in named ranges on a hidden worksheet in each user's file.

    However, if I need to make a change to the content of these lists, I will have to open all 50 files individually and change each one. So I'd like to have a master file to which all the templates would be linked which would contain the entries for each drop-down. So when I update a list in the Master file, it would automatically update the drop-down lists in each user's template with any additions deletions.

    My question is, how do I create the links between the user templates and the master and have it so that the list ranges will be dynamic. So if a drop-down list contains say 10 entries and I add 2 more in the master, that those 12 now appear in each user's template?

    I'd greatly appreciate any ideas on how I could approach this.

  2. #2
    Forum Contributor
    Join Date
    02-09-2014
    Location
    Kamnik, Slovenia
    MS-Off Ver
    Excel 2010
    Posts
    693

    Re: Linking Data Validation Lists to a Workbook

    I believe you'll find something here, video also :

    http://www.contextures.com/xlDataVal05.html

    Regards, Luka

  3. #3
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    127

    Re: Linking Data Validation Lists to a Workbook

    Hi Luka,

    Many thanks for your reply.

    I had seen this solution but it requires the 'Master' workbook to be open, which I don't want.

    Is there any way it could be achieved with the Master workbook closed?

    Thanks.

  4. #4
    Forum Contributor
    Join Date
    02-09-2014
    Location
    Kamnik, Slovenia
    MS-Off Ver
    Excel 2010
    Posts
    693

    Re: Linking Data Validation Lists to a Workbook

    I'm not sure, but probably It could be done with VBA, just don't know how. Sorry, I can't help you on this one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Linking two of the same data validation lists on two separate sheets
    By MarioLamaa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2013, 04:52 AM
  2. Replies: 0
    Last Post: 10-22-2012, 06:52 PM
  3. Linking 2 Data Validation Lists
    By Ben75 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2011, 06:42 PM
  4. Replies: 3
    Last Post: 09-02-2010, 03:04 AM
  5. Data Validation Linking Lists Together
    By AndyMcNeil in forum Excel General
    Replies: 1
    Last Post: 03-27-2007, 02:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1