Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide drop down list | Excel Discussion (Misc queries) | |||
How do i set up a drop down list and hide my list data. | Excel Worksheet Functions | |||
Drop down list with different values. | Excel Worksheet Functions | |||
Clearing the Values in a Drop - Down List | Excel Discussion (Misc queries) | |||
Hide Duplicates in a Drop Down List | Excel Discussion (Misc queries) |