+ Reply to Thread
Results 1 to 3 of 3

Data Validation with two criterias

  1. #1
    Forum Contributor
    Join Date
    05-26-2008
    Posts
    122

    Data Validation with two criterias

    Hi all.. I am just working on a file that was given to me.. Theres basically a menu with a data validation drop down which reads a list.. however the list gets long so what im trying to do is add another drop down above this list
    where i should be able to select the reps name .. and den the validation list below it will only show list of accounts for those reps .. what would be the best way to go about this ?? your help is greatly appreciated.. thanks

    im attaching a file for example... thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor wmorrison49's Avatar
    Join Date
    09-25-2007
    Posts
    267
    When I have wanted to do this, I have used this website as a guide. It is a pretty straight forward walkthrough:

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

  3. #3
    Forum Contributor
    Join Date
    05-26-2008
    Posts
    122
    dat did the trick .. thanks a ton !!

+ 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