HELP FORMULA OR VBA!!!

%3CLINGO-SUB%20id%3D%22lingo-sub-1512557%22%20slang%3D%22en-US%22%3EHELP%20FORMULA%20OR%20VBA!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1512557%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20selection%20based%20on%20user's%20preferences%20from%20the%20list%20in%20the%20attachment.%20Not%20sure%20if%20it%20is%20possible%20in%20excel%20platform.%20For%20example%3B%20If%20you%20look%20at%20in%20the%20attachment%2C%20choosing%20your%20favorite%20fruits%20from%20%22fruits%201%22%20and%20when%20you%20choose%20it%20it%20will%20transfer%20It%20to%20%22SELECTION%201%22.%20Then%20choosing%20your%20favorite%20fruits%20from%20%22fruits%202%22%20and%20when%20you%20choose%20it%20it%20will%20transfer%20It%20to%20%22SELECTION%202%22%20and%26nbsp%3Bchoosing%20your%20favorite%20fruits%20from%20%22fruits%203%22%20and%20when%20you%20choose%20it%20it%20will%20transfer%20It%20to%20%22SELECTION%203%22.%3C%2FP%3E%3CP%3EIn%20reality%20I%20have%20over%2050%20cells%20so%20if%20I%20get%20some%20clue%20I%20can%20make%20it%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1512557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1512592%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20FORMULA%20OR%20VBA!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1512592%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F714984%22%20target%3D%22_blank%22%3E%40msm66%3C%2FA%3E%26nbsp%3B%20I'm%20not%20sure%20I%20understand%20what%20you%20are%20trying%20to%20do%20but%20try%20this%3A%3C%2FP%3E%3CP%3Eselect%20cells%20under%20'Selection%201'%20-%20'Selection%203'%20and%20click%20on%20Data%20-%26gt%3B%20Data%20Tools%20-%26gt%3B%20Data%20Validation%3C%2FP%3E%3CP%3Echoose%20%22List%22%20from%20drop%20down%3C%2FP%3E%3CP%3EThen%20type%20%3DA%242%3AA%2450%20in%20the%20box%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1512671%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20FORMULA%20OR%20VBA!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1512671%22%20slang%3D%22en-US%22%3Ethanks%2C%20I%20know%20how%20to%20create%20drop%20list.%20let%20me%20explain%20better.%3CBR%20%2F%3Elet's%20say%20I%20give%20you%20a%20list%20of%20fruits%20and%20ask%20you%20choose%20the%20one%20you%20like.%20let's%20say%20there%20are%2050%20items%20in%20the%20list%20and%20you%20only%20like%2010%20of%20them%20the%20most.%3CBR%20%2F%3Enow%20you%20start%20selecting%20or%20marking%20or%20checking%20the%20one%20you%20like.%20every%20time%20you%20select%20your%20choice%20will%20enter%20or%20type%20in%20another%20cell.%20or%20even%20you%20can%20select%20all%20in%20one%20time%20and%20through%20maybe%20VBA%20you%20create%20a%20%22run%22%20button.%20by%20clicking%20the%20%22run%22%20all%20your%20choices%20will%20be%20enter%20to%20a%20new%20cell%20one%20on%20one.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eso%20at%20the%20end%20i%20would%20have%20a%20column%20selection%20of%20your%2010%20choices%20of%2050.%20hope%20it%20was%20more%20clear%20now.%3C%2FSPAN%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

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

2 Replies
Highlighted

@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

 

Highlighted
thanks, I know how to create drop list. let me explain better.
let's say I give you a list of fruits and ask you choose the one you like. let's say there are 50 items in the list and you only like 10 of them the most.
now you start selecting or marking or checking the one you like. every time you select your choice will enter or type in another cell. or even you can select all in one time and through maybe VBA you create a "run" button. by clicking the "run" all your choices will be enter to a new cell one on one.
so at the end i would have a column selection of your 10 choices of 50. hope it was more clear now.