data validation
 

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.

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 he

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


wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
he

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


wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.