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.

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

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.

"Carrie" wrote:

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.

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.

"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

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

On Thu, 17 Jul 2008 14:05:00 -0700, Carrie
wrote:

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.

"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

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

"ericm" wrote:

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.

"Carrie" wrote:

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.

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

"Gord Dibben" wrote:

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

On Thu, 17 Jul 2008 14:05:00 -0700, Carrie
wrote:

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.

"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

That's a good one to use<g

Thanks for the feedback


Gord

On Fri, 18 Jul 2008 13:56:04 -0700, Carrie
wrote:

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

"Gord Dibben" wrote:

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

On Thu, 17 Jul 2008 14:05:00 -0700, Carrie
wrote:

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.

"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

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.

"Carrie" wrote:

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

"Gord Dibben" wrote:

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

On Thu, 17 Jul 2008 14:05:00 -0700, Carrie
wrote:

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.

"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

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!!!

"Gord Dibben" wrote:

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

On Thu, 17 Jul 2008 14:05:00 -0700, Carrie
wrote:

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.

"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.

Debra does nice work.

Thanks to Debra and WVR for the feedback.


Gord

On Wed, 10 Jun 2009 07:11:02 -0700, WVR
wrote:

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!!!

"Gord Dibben" wrote:

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

On Thu, 17 Jul 2008 14:05:00 -0700, Carrie
wrote:

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.

"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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 Kan" wrote:

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"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carrie" wrote:

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.