Results 1 to 3 of 3

Linking to Drop List as Master and Slave

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2020
    Location
    we
    MS-Off Ver
    10
    Posts
    5

    Linking to Drop List as Master and Slave

    Help Please. I am trying to create a drop down list for a master control (dashboard). I want to copy it to a anther sheet where it will be used in a formula (Slave). When I copy it with a link I can update the slave from the Master. However, once I change the selection on the Slave, the link is broken

    FYI, I do not mean DEPENDENT DBL as it is normally used. I want to select a value from Master DBL and have it appear (updated) on the SLAVE DBL which is located on a separate WorkSheet. I can do it but as soon as I change the selection in the Slave, the link to the Master is broken.

    The Slave is repeated (Eg for each month) so that different values can be individually selected at the Slave Level. The Master only gives initial control and updates to the Slave.

    Please see attached test file.

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 06-08-2017, 04:28 PM
  2. Master/Slave checkboxes
    By ko6ux in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2014, 08:48 AM
  3. Data between master and slave worksheets
    By estimatingguy in forum Excel General
    Replies: 0
    Last Post: 10-14-2011, 11:47 AM
  4. Master and slave workbooks
    By Lizzietish11 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-31-2009, 02:21 PM
  5. Pass protection from a master to a slave workbook
    By Ducatisto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2009, 03:59 AM
  6. Master & Slave Check Boxes
    By flmoose in forum Excel General
    Replies: 9
    Last Post: 06-06-2008, 03:25 PM
  7. Master/slave files
    By Dohmaker in forum Excel General
    Replies: 1
    Last Post: 02-05-2008, 02:51 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