A New Challange

Closed
Oscar - Feb 2, 2010 at 05:26 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 2, 2010 at 02:30 PM
Hello,
I would like to explain my ques with an example:-
I have created a List which is Oscar1,Oscar2,Oscar3,Oscar4,Oscar5 via using data validation. Now i want after using the drop down i fill one cell value say Oscar2, then in the next cell i want all option will be the in next drop down except Oscar2. Once i filled the name from list i dont want that name again in the list.
Plz help????????????????????///
Urgent requirment....................................

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 2, 2010 at 02:30 PM
It is doable via macro but this will consume too much resources as the sheet continue has to see it the value is changed etc. One approach could be that that you add you list in a separate area. Set the range of list to that. As you pick and item of that list delete the cell from the range, so effectively removing the value from the list.
0