Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178

    Unanswered: Entering data from a drop-down list

    I need to be able to enter data from a drop-down list to reduce errors. However, the drop-down data - lot numbers, sometimes 10 of them - will be dependent on the item number. How do I get Excel to look for data in a dynamic list?

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    So in column A you have item number, and column B is dependent on that? Here is a good explanation from Ozgrid Dependent List Explanation
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Thanks, Rich.

    It's quite complicated and I don't know yet if I can simplify it for the users, but it sure looks good.

    Sam

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    I have used this approach several times for my own work. Once you get the hang of it, it goes rather quickly.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •