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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=523027

suppose i want to restrict values (which are in D2:D10 range) to be
entered in cell B5. how can i do this.

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

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

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=523027

davesexcel Wrote:
suppose i want to restrict values (which are in D2:D10 range) to be
entered in cell B5. how can i do this.

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

i know this method. this method allows values in range D2:D10 to be
entered in cell B5. i actually want to restrict these values (D2:D10)
to be entered in B5. how cant i do this by validation or any other
method.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=523027

davesexcel Wrote:
suppose i want to restrict values (which are in D2:D10 range) to be
entered in cell B5. how can i do this.

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

thanks for replying
infact i know this method. this method allows values in range D2:D10 to
be entered in cell B5. i actually want to restrict these values (D2:D10)
to be entered in B5. how cant i do this by validation or any other
method.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=523027