Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List Filters
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 content of Group and Line not make sense. Is there a way to 'blank out' the group and line lists if the division list is entered/changed? or to force the user to re-enter group and line if division was changed. thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List Filters
General Question - general answer:
You can use an Event Macro [WorkSheet_Change or WorkSheet_SlectionChange in order to clear the other 2 cells and/or display, inside them, something like: "Choose again" assuming those cells hold something like INDIRECT(XX). Please understand that it is not easy - for me - to answer such a question without the WB in front of me Micky "fras_too" wrote: 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 content of Group and Line not make sense. Is there a way to 'blank out' the group and line lists if the division list is entered/changed? or to force the user to re-enter group and line if division was changed. thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List Filters
I am trying to avoid using macros if possible. Is there an alternative that
anyone is aware of. Thank you Micky "מיכאל (מיקי) אבידן" wrote: General Question - general answer: You can use an Event Macro [WorkSheet_Change or WorkSheet_SlectionChange in order to clear the other 2 cells and/or display, inside them, something like: "Choose again" assuming those cells hold something like INDIRECT(XX). Please understand that it is not easy - for me - to answer such a question without the WB in front of me Micky "fras_too" wrote: 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 content of Group and Line not make sense. Is there a way to 'blank out' the group and line lists if the division list is entered/changed? or to force the user to re-enter group and line if division was changed. thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List Filters
An alternative is to use conditional formatting to "hide" the other
selections. Note however, this may be very difficult to figure out. I couldn't do it without seeing the file. Also, it doesn't change the fact that the selection is still physically in the cell, you just won't see it. So, if you have calculations based on these selections then you'd also have to tweak those to account for invalid relationships. IMO, the event macro is the way to go. -- Biff Microsoft Excel MVP "fras_too" wrote in message ... I am trying to avoid using macros if possible. Is there an alternative that anyone is aware of. Thank you Micky "????? (????) ?????" wrote: General Question - general answer: You can use an Event Macro [WorkSheet_Change or WorkSheet_SlectionChange in order to clear the other 2 cells and/or display, inside them, something like: "Choose again" assuming those cells hold something like INDIRECT(XX). Please understand that it is not easy - for me - to answer such a question without the WB in front of me Micky "fras_too" wrote: 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 content of Group and Line not make sense. Is there a way to 'blank out' the group and line lists if the division list is entered/changed? or to force the user to re-enter group and line if division was changed. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do my drop down filters no longer work? | Excel Discussion (Misc queries) | |||
Data Filters - Drop Down | Excel Discussion (Misc queries) | |||
Excel should have a drop down box that shows all the filters on | Excel Worksheet Functions | |||
Drop Down FIlters. | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |