ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i filter dependents already selected in drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/250424-how-do-i-filter-dependents-already-selected-drop-down-list.html)

fras_too

how do i filter dependents already selected in drop down list
 
I've got a three tier dependent list set up for:
Division / Group / Line. (Thanks Debra Dalgliesh)

If a user selects a division, group and line there are no issues. However,
after selecting all three fields, I've had some users go back and change the
contents of the Division. When they do this - it makes the current content of
Group and Line invalid. Is there a way to 'blank out' the group and line
lists if the division list is entered/changed?

thanks in advance


All times are GMT +1. The time now is 11:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com