+ Reply to Thread
Results 1 to 3 of 3

Linking to Drop List as Master and Slave

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

    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

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,666

    Re: Linking to Drop List as Master and Slave

    there is nothing magical about a drop down (Data Validation). It is exactly the same as if you had typed the entry in manually, the only differences being that a DD can save you some typing, help avoid typos and help restrict entry to only a specified "list". Other than that, there is basically no difference. You would refer to it in formulas etc the exact same way as if you were referencing a manually entered cell

    Based on what you describe, you want a formula in the 2nd DD cell, but still have it function as a DD - this is not possible (without VBA)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

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

    Re: Linking to Drop List as Master and Slave

    thanks FDibbins, I have not learned VBA yet, is it a complicated program?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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