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