data validation

[amy]

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]

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]

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

.