+ Reply to Thread
Results 1 to 5 of 5

Connected lists

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    GREECE
    MS-Off Ver
    Excel 2010
    Posts
    47

    Connected lists

    Hi i have a problem with lists. I have a cell(1) with a drop down list with where i have tow choices and in the other cell(2) i want to have two different lists where when i make a choice in cell(1) i want to give me the proportionate selection list in cell (2).

  2. #2
    Forum Contributor
    Join Date
    03-12-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    230

    Re: Connected lists

    You could create a virtual named range. Go to "Name Manager" and click "New". Name a new rule and write an IF statement with the two selections as the true or false results. Now for your second drop-down list, just use the name that you created for the rule and it should work fine.

  3. #3
    Registered User
    Join Date
    03-21-2013
    Location
    GREECE
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Connected lists

    Thnx for the answer but i try it and i can't do it .

  4. #4
    Forum Contributor
    Join Date
    03-12-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    230

    Re: Connected lists

    I can take a look at it if you include the workbook.

  5. #5
    Registered User
    Join Date
    03-21-2013
    Location
    GREECE
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Connected lists

    Is ok i finally make it .Thnx

+ 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