Take a list from one workbook and apply asdropdown in another work
 

I have created a list in one workbook now I want to take that list and apply
it as a dropdown to select which word I want to use in another workbook. How
can I do this

Take a list from one workbook and apply asdropdown in another work
 

<Data<Validation...
Select "List" in the drop-down
Enter your list range (from the other sheet) in the "Source" box

Does that help?
--
Regards,
Dave


"Nathan" wrote:

I have created a list in one workbook now I want to take that list and apply
it as a dropdown to select which word I want to use in another workbook. How
can I do this

Take a list from one workbook and apply asdropdown in another work
 

Nathan

You must name the source list.

See Debra Dalgeish's site for more on this.

http://www.contextures.on.ca/xlDataVal05.html


Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 08:48:02 -0800, Nathan
wrote:

I have created a list in one workbook now I want to take that list and apply
it as a dropdown to select which word I want to use in another workbook. How
can I do this