Drop Down List Filters

[fras_too]

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

 

[מיכ×ל (מיקי) ×בידן]

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]

I am trying to avoid using macros if possible. Is there an alternative that
anyone is aware of. Thank you Micky

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

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

 

[T. Valko]

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

I am trying to avoid using macros if possible. Is there an alternative that
anyone is aware of. Thank you Micky

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

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