Can I insert Drop Down list made up of items from another sheet?

Posted on 2011-04-26
Last Modified: 2012-05-11
Can I provide a drop down list in a cell and have that list consist of items from an ever-changing list on another sheet??   On the attached sample ~  Can I have them click on a cell in column J "Eng Units" and get a drop down list made up of all items on the sheet "LIST"  ??   Even though the "LIST" may be changing/expanding all the time???   Thanks FORMandLISTpractice.xls
Question by:SRMoxy
    LVL 33

    Expert Comment

    You should use a Named Range as the source for your Data Validation list.
    LVL 33

    Expert Comment

    LVL 33

    Accepted Solution

    Please take a look at the attached example using your file.


    Author Closing Comment

    Perfect!   Thanks a bunch!!!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now