A
AA Arens
I have created a list via Insert > Name > Define.
On a list of cells I want to let the user choose a value from the
defined list. Is it possible to shorten the list when a value is
already choosen at another cell?
So:
List = AA, BB, CC, DD.
Cell 1: BB is choosen
Cell 2: list is AA, CC, DD. I choose DD etc.
Bart
Excel 2003
On a list of cells I want to let the user choose a value from the
defined list. Is it possible to shorten the list when a value is
already choosen at another cell?
So:
List = AA, BB, CC, DD.
Cell 1: BB is choosen
Cell 2: list is AA, CC, DD. I choose DD etc.
Bart
Excel 2003