Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2011-04-26
Medium Priority
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
  • 3
LVL 33

Expert Comment

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

Expert Comment

ID: 35469628
LVL 33

Accepted Solution

jppinto earned 2000 total points
ID: 35469644
Please take a look at the attached example using your file.


Author Closing Comment

ID: 35469782
Perfect!   Thanks a bunch!!!!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

577 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