Hide values in a Drop Down list
I have followed the contectures website to no avail.
I am trying to creat a fantasy football draft wroksheet and I have 7 drop down options: Top200, QB, RB,WR,TE,K, DEF With each of these drop downs is also a column with Taken. If they are taken then the status changes to yes. SO I want to be able to edit the data in the drp down list to validate the the player is not taken and if they are taken to remove them fromthe list. Any ideas? THANKS! |
Hide values in a Drop Down list
hi, !
I'm not so sure this is *NOT* what you look for -?- - Excel - Data Validation - Hide Previously Used Items in Dropdown http://www.contextures.com/xlDataVal03.html hth, hector. __ OP __ I have followed the contectures website to no avail. I am trying to creat a fantasy football draft wroksheet and I have 7 drop down options: Top200, QB, RB,WR,TE,K, DEF With each of these drop downs is also a column with Taken. If they are taken then the status changes to yes. SO I want to be able to edit the data in the drp down list to validate the the player is not taken and if they are taken to remove them from the list. Any ideas? |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com