| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table question | Excel Discussion (Misc queries) | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Data Validation Syntax Question | Excel Discussion (Misc queries) | |||
| Validation Data & Goto question | Excel Discussion (Misc queries) | |||
Linear Mode
