Data Validation

[starguy]

please any one tell me how can i restrict a range of values to enter i
a cell by using data validation of some other method.
suppose i want to restrict values (which are in D210 range) to b
entered in cell B5. how can i do this

 

[davesexcel]

suppose i want to restrict values (which are in D210 range) to b
entered in cell B5. how can i do this.

select B5
Goto
Data
Validation
Select list
In the range box enter D210
You now have a drop down menu

Check out this site for more on Data Validation, You could also searc
your forum

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

 

[starguy]

suppose i want to restrict values (which are in D210 range) to b
entered in cell B5. how can i do this.

select B5
Goto
Data
Validation
Select list
In the range box enter D210
You now have a drop down menu

i know this method. this method allows values in range D210 to b
entered in cell B5. i actually want to restrict these values (D210
to be entered in B5. how cant i do this by validation or any othe
method

 

[starguy]

suppose i want to restrict values (which are in D210 range) to b
entered in cell B5. how can i do this.

select B5
Goto
Data
Validation
Select list
In the range box enter D210
You now have a drop down menu

thanks for replying
infact i know this method. this method allows values in range D210 t
be entered in cell B5. i actually want to restrict these values (D210
to be entered in B5. how cant i do this by validation or any othe
method