Dropdown List from a worksheet located on another drive

[techcrash1]

I have a list of names in a Excel worksheet located on drive U and I want to create a dropdown list in a particular cell in a Excel worksheet located on drive E. How do you set this up by using the validation feature in Excel 2000.

[MDuff]

As far as I know validation can't be done in 2 different worksheets but one way you could do this is link the sheet on drive Q to the One on drive E and bring the information in to the sheet on drive E and make your data validation from that where MD is on this sheet is the validation and the data in A is comming from an other workbook

******** ******************** ************************************************************************>

Microsoft Excel - Book5 ___Running: xl2000 : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A1A2A3A4A5 =
	A	B	C	D
1	md	*	md	*
2	md	*	*	*
3	md	*	*	*
4	md	*	*	*
5	md	*	*	*
Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[Ekim]

I have a list of names in a Excel worksheet located on drive U and I want to create a dropdown list in a particular cell in a Excel worksheet located on drive E. How do you set this up by using the validation feature in Excel 2000.

I think it’s doable. See some instructions here under the heading “Data Validation -- Use a List from Another Workbook” http://www.contextures.com/xlDataVal05.html

The instructions do not relate to different drives, but theoretically it seems possible. There are two things to note:
1. The file on drive U must be open for the validation to work in the file located on drive E.
2. The list in the file on drive U must be a named range.

HTH

Mike