Is it possible to select a multi value from a drop down box

C

Carrie

I'm working on a spreadsheet in Excel 2007 and I'm trying to get it in one
cell where you can select multiple items to go in that cell. I don't know
if it is possible but if it is please help me.
 
M

M Kan

Can you provide an example of what you are trying to concatenate together.
You can use the CONCATENATE function to combine cell values or the & symbol
to combine cell values and text. For example, the formula:

="Last Updated "&A1&" by "&B1" where A1=Monday and B1=MKan would give you
"Last Updated Monday by MKan"
 
C

Carrie

I am bringing in a data source which has multiple options to choose from and
I'm needing it to where I can pick which ones I want. I hope this makes
since, this is all new to me and the first time I've tried to do this.
 
M

M Kan

I guess I misunderstood initially.

Are you trying to pick from multiple tables or are you trying to pick from
multiple rows/columns, from a single data table?
 
E

ericm

Are you talking about being able to click on that cell and then a selection
of choices appear from where you can choose which one you want to put into
that cell? If so, you're probably wanting a drop-down box. I don't know how
to do that (I'm new too) but I'm sure comeone else here does. But if that's
what you want it's called a dropdown box (in MS Word at least) and I'm sure
MS Excel has a version available.
 
C

Carrie

Example: I'm in cell C3 and I want to bring the table I brought in from my
date source on sheet 4 which are different coverages we offer. I want to be
able to pick the coverages I need without the whole table going in that cell.
I will be repeating this in column C serveral times. I'm sorry I don't know
how to word things so well, thank you so much for helping me.
 
G

Gord Dibben

You can do this using Data Validation dropdown where you select multiple items
from the dropdown but some VBA code is necessary.

See Debra Dalgleish's site for an example workbook.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a
dropdown list; an event macro stores selections in adjacent cell, or in same
cell. DataValMultiSelect.zip 18kb updated 22-Feb-07


Gord Dibben MS Excel MVP
 
C

Carrie

Thank you all for your help, I will let you know which way worked the best
for what I'm doing. Again thank you
 
C

Carrie

The Link you gave me did help me to get what I was needing, thank you. Here
is the one I used:
DV0017 - Select Multiple Items from Dropdown List-- Select multiple items
from a dropdown list; an event macro stores selections in adjacent cell, or
in same cell. DataValMultiSelect.zip 18kb
 
J

Jennifer

I have a similar need to be able to select multiple items from a drop down
list. I've used VBA code from the Contexture site for adding items to the
same cell in the DataValMultiSelect.zip example. It works great. But
whenever I try to edit the contents of the cell, I get a data validation
error. I'd like to be able to remove items from the list as they are
completed. Thanks.
 
W

WVR

This is AWESOME! I'm new to this discussion group and I needed to do
exactly what was asked originally here (i.e., ability to select multiple
options from a drop down). The link you provided was exactly what I needed.
Thanks!!!
 
Top