A New Challange
Closed
Oscar
-
Feb 2, 2010 at 05:26 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
1 reply
rizvisa1
Feb 2, 2010 at 02:30 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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.