Data validation

[Scottmk]

Hi...I am trying to store a list in a seperate worksheet and the
reference it on my other worksheets. When I go to data validation an
try to do this, i get the message "you may not reference anothe
worksheet or workbook for data validation." My cpu at home has exce
2003, this one has 2002. Any ideas or workarounds? Thank

 

[Frank Kabel]

Hi

Try the following:
- select your list
- create a defined name for this list ('Insert - Name Define')
- use this name in your data validation formula. e.g.
=Name_list

have a look at the following
http://www.contextures.com/xlDataVal05.html
for further instructions how to access a list from a different
worksheet/workbook using defined names.

 

[Scottmk]

Done deal...thanks