Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"Alzheimer'sResearch" wrote
in message ...
On one sheet, I would like to have a list of names (travelers in my case)
which I would assume I would need to define as a group. I would like the
first column of cells on ANOTHER sheet in the workbook to each have a drop
down menu when clicked upon, that lists every name (from the previous
sheet)
so that you can choose which name to put in the cell. Is this possible in
Excel? In the end, I basically would want one sheet to store all the
names,
then as many sheets as needed for different projects where I could just
draw
upon those names with drop down menus.
Thanks for any help!