+ Reply to Thread
Results 1 to 3 of 3

Dropdown list which values change based on a reference to another cell

  1. #1
    Registered User
    Join Date
    05-14-2018
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    12

    Question Dropdown list which values change based on a reference to another cell

    Hello All,
    I am finishing up a big workbook with many VBAs, sheets referencing other sheets, sheets putting data into another sheets, graphs and more. I am stuck on one of my last items if someone could help me out.

    I am looking for a drop down list, which values changes, based on the value of another cell. To hopefully explain fully:

    I have a chart on sheet ‘Chart’ to track inventory accuracy in my plant. In A1 I have a drop down list of all of our parts. This is linked to another sheet called ‘Data’. Some of our product is located in different warehouses, ie, Finish Good, Production, Raw Material etc.. A product may be in 1, 2 or more warehouses. When counting our inventory, we apply a counting tolerance based on how hard it is to count an item. What I am looking for, the drop down list under Warehouse to only show the warehouse that I have said that product belongs, which can be found in the same list on my ‘Data’ sheet.

    Here is an example of my ‘Data’ Sheet. I have around 300 lines of different parts/Warehouses.
    Please Login or Register  to view this content.
    On my ‘Chart’ sheet, when I select say Part 1 in cell A1, I want the drop down list in B1 only to show warehouse Finish Good and Raw Material as its only in these 2 warehouses as stated on my ‘Data’ sheet. Part 2 will only show Finish Good, and Part 3 will only show Production and Raw Material. I have cells C1 show the tolerance based on an Index and Match based on cells A1 & B1.

    My current work around is my list in B1 has all the possible warehouses, but I don’t want the end user to be able to select a warehouse that is not allowed.

    If this is possible, I appreciate the help. If you need any more information, let me know and I will provide it,
    Thanks,
    -Tom

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Dropdown list which values change based on a reference to another cell

    Hi Tom,

    Certainly sounds possible, but would be a lot easier to help if you could attach the workbook so we could see it in context.
    You see, what you call a drop down could be in cell validation or a combobox sat over a cell and each would have a different approach to the solution.

    BSB

  3. #3
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Dropdown list which values change based on a reference to another cell

    G'day Tom,

    If I understood you click on the link below. Most of the information you need half way down the page, but please understand the first half of the page before attempting the rest of it.

    Click Here
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

+ 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. VBA button that emails from a dropdown list based on cell values
    By Chocobits in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-23-2017, 02:10 AM
  2. Change reference cell in formula based on selection in drop down list
    By devin.fentie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2016, 03:40 AM
  3. Replies: 3
    Last Post: 11-13-2015, 05:10 AM
  4. [SOLVED] Populate in-cell dropdown list with values based on sheet name
    By mks16 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-21-2015, 09:35 AM
  5. [SOLVED] Display a dropdown list or populate a cell with single value based on other cells' values
    By filla_dilla in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2014, 09:47 AM
  6. Changing other cell values based on Dropdown list
    By FransB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2014, 04:00 AM
  7. Cross Reference (Vlookup) based on Data Validation List Dropdown
    By eguirocker3 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2014, 05:02 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