data validation

amy · Feb 25, 2005

Hello,

I have try out couple of times to setup a validation in
excel spreadsheet from different spreadsheets and I can't
allow me to proceed.

I can setup the validation in same spreadsheet but not in
different spreadsheet.

Appreciate your advise.

Debra Dalgleish · Feb 25, 2005

If you name the list on the other sheet, you can refer to it by name in
the data validation dialog box. There are instructions here:

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

Guest · Feb 25, 2005

TQ. I got it.

-----Original Message-----
If you name the list on the other sheet, you can refer to it by name in
the data validation dialog box. There are instructions here:

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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

data validation

amy

Debra Dalgleish

Guest