Question on Validation
 

Is it not possible to create a list for validation from another
worksheet OR have I done any changes in the settings?
Is it necessary that the list be present in the same worksheet where I
am having a validation function?
Regards

Question on Validation
 

Check this site out, and I would suggest bookmarking it.
http://www.contextures.com/xlDataVal05.html
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Manju" wrote:

Is it not possible to create a list for validation from another
worksheet OR have I done any changes in the settings?
Is it necessary that the list be present in the same worksheet where I
am having a validation function?
Regards

Question on Validation
 

To use a list on a different worksheet in the same workbook, you can
name the range that contains the list. There are instructions he

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

Manju wrote:
Is it not possible to create a list for validation from another
worksheet OR have I done any changes in the settings?
Is it necessary that the list be present in the same worksheet where I
am having a validation function?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Question on Validation
 

Thanks
Debra Dalgleish wrote:
To use a list on a different worksheet in the same workbook, you can
name the range that contains the list. There are instructions he

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

Manju wrote:
Is it not possible to create a list for validation from another
worksheet OR have I done any changes in the settings?
Is it necessary that the list be present in the same worksheet where I
am having a validation function?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html