You may find this site useful.

http://www.contextures.com/xlDataVal08.html

In addition, her site of
http://www.contextures.com/tiptech.html
has so many helpful hints, you may wanna bookmark it :)


--
John C


"ConfusedKip" wrote:

I am entering information into a spreadsheet and making drop down lists from
that information. I can get it to work in the same sheet, but I cannot make
the same drop down list work in a new document. I have named it, and I have
followed the directions on here, but I must not understand because it is not
working. I don't know if there is a function or formula I need? Please tell
me how to make a drop down list from information that is in a different excel
file. Thanks!