+ Reply to Thread
Results 1 to 3 of 3

Expanding Data validation from List

  1. #1
    mark hansen
    Guest

    Expanding Data validation from List

    I have created many spreadsheet for other users and have tried to set them
    up, as much as possible, so they add their own information into cells so
    they can be in the data validation from list drop down boxes. I have had to
    go back and add more room in the data validation list because it was longer
    than I expected.

    Is there I way I can set up the data validation so the list they get will
    grow when they add more to the list?

    Thanks
    Mark



  2. #2
    Norman Jones
    Guest

    Re: Expanding Data validation from List

    Hi Mark,

    Try using a dynamic range for the Data Validation List.

    For information on the use of dynamic ranges, see Debra Dalgleish's page on
    dynamic ranges at:

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


    ---
    Regards,
    Norman



    "mark hansen" <[email protected]> wrote in message
    news:[email protected]...
    >I have created many spreadsheet for other users and have tried to set them
    >up, as much as possible, so they add their own information into cells so
    >they can be in the data validation from list drop down boxes. I have had
    >to go back and add more room in the data validation list because it was
    >longer than I expected.
    >
    > Is there I way I can set up the data validation so the list they get will
    > grow when they add more to the list?
    >
    > Thanks
    > Mark
    >




  3. #3
    mark hansen
    Guest

    Re: Expanding Data validation from List

    That did the trick, thanks for pointing me in that direction. I love the
    web site, LOTS of great information and examples. Thanks for not only
    helping, but pointing me to a great resource on the web.

    Mark


    "Norman Jones" <[email protected]> wrote in message
    news:[email protected]...
    > Hi Mark,
    >
    > Try using a dynamic range for the Data Validation List.
    >
    > For information on the use of dynamic ranges, see Debra Dalgleish's page
    > on dynamic ranges at:
    >
    > http://www.contextures.com/xlNames01.html#Dynamic
    >
    >
    > ---
    > Regards,
    > Norman
    >
    >
    >
    > "mark hansen" <[email protected]> wrote in message
    > news:[email protected]...
    >>I have created many spreadsheet for other users and have tried to set them
    >>up, as much as possible, so they add their own information into cells so
    >>they can be in the data validation from list drop down boxes. I have had
    >>to go back and add more room in the data validation list because it was
    >>longer than I expected.
    >>
    >> Is there I way I can set up the data validation so the list they get will
    >> grow when they add more to the list?
    >>
    >> Thanks
    >> Mark
    >>

    >
    >




+ 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