I have a list i.e.
List 1
Apple
Pear
Oranges
Challenge:
I would like to have a drop down box select a product from List 1 (Easily done)
However, in another column, it would populate all but the selected item from List 1.
The challenge is to do this without VB code. (And also the list could possibly contain over 30 items.)
Thanks for any help you can provide.
Results
Selection: Apple
List 1 List 2
Apple Orange
Orange Pear
Pear
List 1
Apple
Pear
Oranges
Challenge:
I would like to have a drop down box select a product from List 1 (Easily done)
However, in another column, it would populate all but the selected item from List 1.
The challenge is to do this without VB code. (And also the list could possibly contain over 30 items.)
Thanks for any help you can provide.
Results
Selection: Apple
List 1 List 2
Apple Orange
Orange Pear
Pear