Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down list
hi
i have created a drop list for validating all cells on column E, and i would like the same list to appear on column G but without the value choosen on the relevan E cell on the same row. this process should continue to columns I, K and so forth, each time the list should include all the values that were not chosen in previous cells on the same row. this must apply to all rows from row 10. is there a way to do it ? thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down list
There's a sample file here that hides previously selected items in each
row, using data validation lists: http://www.contextures.com/excelfiles.html Unde Data Validation, look for 'DV0016 - Assign Employees to Single Task Per Day' Guye wrote: hi i have created a drop list for validating all cells on column E, and i would like the same list to appear on column G but without the value choosen on the relevan E cell on the same row. this process should continue to columns I, K and so forth, each time the list should include all the values that were not chosen in previous cells on the same row. this must apply to all rows from row 10. is there a way to do it ? thanks. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |