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.