+ Reply to Thread
Results 1 to 3 of 3

data validation-What I want to happen

  1. #1
    Registered User
    Join Date
    04-25-2007
    Posts
    38

    data validation-What I want to happen

    Hi All

    I have a bit of an involved problem...

    To try and explain this clearly imagine a number of columns, each of which represents a job, and at the top of each column is a cell that contains a drop down list with people listed in it......so far so good and easy to set up but here's the difficult bit......assuming there were 10 names in the list and I pick one of the names in the first column for the first job.

    What I want to happen then is for the name that I picked to disappear from the list in all the other jobs so it can't get picked again. So now the list only shows 9 names. Similarly when I pick a name from the 9 names for job 2, that name now disappears from the list and there are 8 names that show for job 3, etc.

    Also, just to make it a little harder, instead of going from job 1 to job 2 to job 3 etc, I might go to job 10, then job 2, then job 6 for example and as I pick the names they disappear from the list whichever way round I do it

    I'm TOTALLY confused as to where to start or even if this is possible in excel. It does sound more like a database thing where you could have 2 flags, one for 'available on list' and one for 'used already'

    Absolutely any help would be gratefully received

  2. #2
    Registered User
    Join Date
    04-25-2007
    Posts
    38
    I guess this must be tricky then

    Anyone got any ideas, or maybe confirm it can't be done

  3. #3
    Registered User
    Join Date
    04-25-2007
    Posts
    38
    Ok guys, just as an update and in case anyone else can use the solution, here it is...

    http://www.contextures.com/excelfiles.html#DataVal


+ 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