Jul 09 2020 11:08 AM
I am trying to create a selection based on user's preferences from the list in the attachment. Not sure if it is possible in excel platform. For example; If you look at in the attachment, choosing your favorite fruits from "fruits 1" and when you choose it it will transfer It to "SELECTION 1". Then choosing your favorite fruits from "fruits 2" and when you choose it it will transfer It to "SELECTION 2" and choosing your favorite fruits from "fruits 3" and when you choose it it will transfer It to "SELECTION 3".
In reality I have over 50 cells so if I get some clue I can make it work.
Thanks a lot
Jul 09 2020 11:20 AM
@msm66 I'm not sure I understand what you are trying to do but try this:
select cells under 'Selection 1' - 'Selection 3' and click on Data -> Data Tools -> Data Validation
choose "List" from drop down
Then type =A$2:A$50 in the box
Jul 09 2020 11:49 AM