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.