validation
 

hi
how am i to apply validate to a particular column
based on the values from diffrent worksheet?
thanks
--
hemu

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

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

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