+ Reply to Thread
Results 1 to 2 of 2

Validation List -adding data and using it later

  1. #1
    POC
    Guest

    Validation List -adding data and using it later

    Hi all, I've been searching the site and haven't found an answer to my
    question.

    I'm trying to use a validation list to allow entry of medical diagnosis.
    Since there are lots of diagnosis, I need my list to be able to be added too.
    I would *like* to have it setup so that any user can enter a "new" diagnosis
    on the worksheet, and it will be added to the validation list on the
    "sheet1". Also, any user after that when they activate the drop down box
    under "Diagnosis" can see that "new" diagnosis listed along with all the ones
    I have originally entered.
    Is what I'm wanting to do possible with Excel?
    Thanks


  2. #2
    Biff
    Guest

    Re: Validation List -adding data and using it later

    Hi!

    You can create a dynamic named range for the diagnosis list.

    http://contextures.com/xlNames01.html#Dynamic

    Then, just use this named range as the source for the drop down.

    Biff

    "POC" <POC@discussions.microsoft.com> wrote in message
    news:072D4B07-4337-479B-80C5-A48EEEC17AA6@microsoft.com...
    > Hi all, I've been searching the site and haven't found an answer to my
    > question.
    >
    > I'm trying to use a validation list to allow entry of medical diagnosis.
    > Since there are lots of diagnosis, I need my list to be able to be added
    > too.
    > I would *like* to have it setup so that any user can enter a "new"
    > diagnosis
    > on the worksheet, and it will be added to the validation list on the
    > "sheet1". Also, any user after that when they activate the drop down box
    > under "Diagnosis" can see that "new" diagnosis listed along with all the
    > ones
    > I have originally entered.
    > Is what I'm wanting to do possible with Excel?
    > Thanks
    >




+ 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