| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
validation
hi
how am i to apply validate to a particular column based on the values from diffrent worksheet? thanks -- hemu |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
validation
You must name the range in the other sheet and then when you refer to the
range in validation you would enter: =NameRange Hope this helps from a beautiful day in South Africa "Hemant_india" wrote: hi how am i to apply validate to a particular column based on the values from diffrent worksheet? thanks -- hemu |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
validation
thanks Les G
should i use =worksheetname!namedrange? thanks and enjoy a beautiful day in South Africa -- hemu "Les G" wrote: You must name the range in the other sheet and then when you refer to the range in validation you would enter: =NameRange Hope this helps from a beautiful day in South Africa "Hemant_india" wrote: hi how am i to apply validate to a particular column based on the values from diffrent worksheet? thanks -- hemu |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
validation
That SHOULD work, but not necessary to append the worksheet name
"Hemant_india" wrote: thanks Les G should i use =worksheetname!namedrange? thanks and enjoy a beautiful day in South Africa -- hemu "Les G" wrote: You must name the range in the other sheet and then when you refer to the range in validation you would enter: =NameRange Hope this helps from a beautiful day in South Africa "Hemant_india" wrote: hi how am i to apply validate to a particular column based on the values from diffrent worksheet? thanks -- hemu |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
![Hemant_india[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
