You simply create a formula that references them.
e.g. If dropdown is in A1, then formula is =A1 if you are in another sheet, then ='Sheet1'!A1 where Sheet1 is name of sheet where drop down is.
I'm not sure what category this question falls into...
I have created multiselect drop down menus in a spreadsheet.
I want to know how I can extract the users choices into another cell in the spreadsheet.
Any help would be appreciated
You simply create a formula that references them.
e.g. If dropdown is in A1, then formula is =A1 if you are in another sheet, then ='Sheet1'!A1 where Sheet1 is name of sheet where drop down is.
NBVC
Thanks for your reply. What you suggested works when the user can only select one item in the drop down. When the user has the option to select more than one, is where I'm stuck.
Where are you sending the selected items?
NBVC
That's part of the mystery. When you use a ListBox as opposed to a conventional drop down menu, I have no idea where the data is stored.
Developer->Controls->Insert->Form Controls->List Box
The list box is not tied to a cell. It sort of sits where ever you like "above" the cells.
Duplicate thread.
Bookmarks