Data validation

H

Henk

In data validation I'm trying to refer to a list in a different sheet but I
didnt work. I have followed the help function in Microsoft but I keep getting
the message that in data validation you cannot refer to a list in a different
workbook.
 
J

Jasper

Hey Henk (Sounds dutch to me),

it is very hard if not impossible to use a validation list with data from
other work sheets.

If it is somehow possible you should try to get the information in the same
sheet as the validationlist.

I myself use =IF('Sheet1'!A17="";"";'Sheet1'!A17) copy it till row 3000
somthing, and then hide the collum.

Works almost perfect.

Additional information can be required using a VLOOK option
=VLOOKUP(D17;'Sheet1'!A17:L41;8;FALSE)

Have fun, Groeten

Jasper
 
A

Arvi Laanemets

Hi

Let you have a list on Sheet2 in range A1:A10. Create a named range MyList
(select the range with list, and then from menu Insert.Name.Define - type in
the range name.
On p.e. Sheet1, select the range/cell you want to use the validation list.
Set the list source as:
=MyList

(Next step will be making the named range dynamic - so your validation list
will be updated whenever you add or remove items in your list)
 
R

RagDyeR

Debra Dalgleish's web site explains how to easily accomplish this:

http://www.contextures.com/xlDataVal05.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

In data validation I'm trying to refer to a list in a different sheet but I
didnt work. I have followed the help function in Microsoft but I keep
getting
the message that in data validation you cannot refer to a list in a
different
workbook.
 
K

Karen

For the future reference of anyone seeking a solution to the same problem,
check the file name of the worksheet which contains your list. If it contains
a space, that is likely your problem.

I had the exact same error message as Henk, but when I changed my file name
from "Telecom Staff List.xls" to "Telecom_Staff_List.xls" it worked.
 
Top