Results 1 to 4 of 4

Data Validation in cell X depending upon the value in cell Y?

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Data Validation in cell X depending upon the value in cell Y?

    I have a worksheet with a list of teams: A, B, C, etc and in cell a1 I have data validation set to that list, so that the team names can be picked from a drop-down

    I then have separate lists for the name of people in each team. E.g:
    Team A has a list containing alice, bill, george, etc
    Team B has a list containing brian, dave, sue, etc
    :
    :

    What I'd like is,
    if I select Team A in cell a1, to be able to have JUST Team A's list available from the drop down in cell b1.
    but if I select Team B in cell a1, to be able to have JUST Team B's list available from the drop-down in b1
    ETC, Etc, etc ...

    Any ideas how this might best be achieved, please?
    Last edited by gjfreem; 08-17-2012 at 12:50 PM.

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