+ Reply to Thread
Results 1 to 3 of 3

Automatically remove entries from one list depending on values selected from another

  1. #1
    Registered User
    Join Date
    06-26-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Question Automatically remove entries from one list depending on values selected from another

    Hello Forum members!

    I urgently need help with something I am unable to solve.

    I have two lists. What I want to do is omit some options automatically from the second list depending on some options selected from the first.

    Guess this shouldnt be very difficulat but cant get my head around it.

    Please refer to sample (Trial sheet.xls)

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Automatically remove entries from one list depending on values selected from another

    Hi,

    Take a look at the attached. Hope that helps.

    Regards
    Attached Files Attached Files
    Click * below if this answer helped

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

  3. #3
    Registered User
    Join Date
    06-26-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Thumbs up Re: Automatically remove entries from one list depending on values selected from another

    Thanks XOR LX it works.

    I also tried using an IF condition in the data validation source for Code 2. That works too!

    Thanks for your help.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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