+ Reply to Thread
Results 1 to 4 of 4

Restrict choice in List B after making choice from List A.

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Melbourne, Aus
    MS-Off Ver
    Excel 2010
    Posts
    9

    Restrict choice in List B after making choice from List A.

    Hey guys, here's an easy one (for the likes of you, not me).

    I want to create a drop down list in B3 based on the choice made from another list in A3.

    In the Example document attached, I want A3 of "Matrix" to have a drop down list of all options in Col A of "Positions", I then need B3 of "Matrix" to have a drop down list of the options available from the choice in A3 based on the list in Column B of "Positions".

    Ie. A3 Choice is "Government Representative", means the drop down list in B3 is restricted to the options next to Government Representative in "Positions".

    I hope that makes sense.

    Cheers
    FF
    Attached Files Attached Files

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Restrict choice in List B after making choice from List A.

    You need depanted validation lists. TaKE a look to this.

    http://www.contextures.com/xlDataVal02.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    04-17-2013
    Location
    Melbourne, Aus
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Restrict choice in List B after making choice from List A.

    Thanks, but this was not as helpful as it could have been. Both my lists contain multiple words and there is no tutorial for that.

    Any more help out there?

    FF

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Re: Restrict choice in List B after making choice from List A.

    I don't have any suggestions, I'm just working with the same problem myself right now.

    We are a manufacturing company that makes castings. Most of our castings go from one raw casting to one specific finished product. A simple one-to-one relationship. However, about 20% of our products are a one-to-many relationship; one raw casting is machined into multiple finished products (anywhere from 2 to 7 different parts).

    We are trying to keep track of our scrap more accurately and I was trying to design a simple spreadsheet to enter the data twice daily, first thing in the morning I enter the night shift scrap, then at 5pm I enter the day shift scrap. We have 3 separate areas in the company that generate scrap: casting, finishing and CNC. We also have day shift, night shift, and weekend shift (both day and night).

    I have attached an example spreadsheet that shows what I am trying to capture. I have used data validation to generate drop-down lists for everything that makes sense. However, I don't know how to handle the one-to-many relationship. I tried, but it won't work using the method in the link.

    I need in column A, the wip part number drop down menu, I need to see option D only once; once that is selected I need to move to column B and from the drop-down menu there I need to select finished product 4, 5 or 6.

    I was wondering if anybody knew a way around this. I am stuck.

    Thanks,

    CG
    Attached Files Attached Files

+ 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