Quantcast

Maximum PC

It is currently Mon Dec 22, 2014 7:48 pm

All times are UTC - 8 hours




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: Any MS Excel gurus on here?
PostPosted: Sun Jun 01, 2014 8:32 pm 
Little Foot
Little Foot

Joined: Thu Apr 03, 2014 9:34 pm
Posts: 122
Location: Portage, IN
I have a question regarding using Data Validation to add multiple entries to one cell, I will describe below. But I would also like to know if anyone knows of a great Excel forum that I can use to ask questions like the one below. I currently belong to excelforum.com and they give sometimes helpful but basic knowledge. To get the real good help one has to pay a subscription fee.

Is it possible to create a formula using a Data Validation List where it will add a new entry to the existing entries in a cell?
For example: I have a data validation list with the names of Pete, Chris, Bruce, Carly, Megan, and Becky. With the normal data validation set I can select one entry and it will be output into the designated cell. E.g. If I select Bruce then Bruce with be placed in the cell.
Is it possible to set it up so that each time I click on data validation it will add an entry to the already existing entry? E.g. I have already selected Bruce then I decide to add Becky, I want the output cell to show both Bruce and Becky.

I know I can do this with a formula that will place all the results from different cells into a single cell, but I would then have to create multiple data validation entries of which I would rather avoid if possible. Not to mention I don't remember how to do this formula anyway......

Bruce


Top
  Profile  
 
 Post subject: Re: Any MS Excel gurus on here?
PostPosted: Sun Jun 01, 2014 9:02 pm 
Smithfield
Smithfield

Joined: Sun Jun 18, 2006 7:37 pm
Posts: 5538
A quick Google search points me to this requiring a VB script to work.


Top
  Profile  
 
 Post subject: Re: Any MS Excel gurus on here?
PostPosted: Mon Jun 02, 2014 11:01 pm 
Little Foot
Little Foot

Joined: Thu Apr 03, 2014 9:34 pm
Posts: 122
Location: Portage, IN
Yes, that is true. Someone on the forums who actually knows what he is doing with VBA is helping me out. I should have my problem solved soon enough.

Bruce


Top
  Profile  
 
 Post subject: Re: Any MS Excel gurus on here?
PostPosted: Sat Jun 21, 2014 7:27 am 
Coppermine
Coppermine
User avatar

Joined: Wed Mar 25, 2009 4:40 pm
Posts: 742
If this is being done through a forum, or can be easily communicated here, please keep us updated - I'd be interested in it for my work, too.

Thanks!


Top
  Profile  
 
 Post subject: Re: Any MS Excel gurus on here?
PostPosted: Sat Jun 21, 2014 8:05 am 
Little Foot
Little Foot

Joined: Thu Apr 03, 2014 9:34 pm
Posts: 122
Location: Portage, IN
Well, the guy that was helping me, gave up, or at least I presume he did. The code he gave me had to be tweaked a few times and on the last problem I reported he hasn't responded. So I am assuming you can't actually do it. If you would like I can give you the examples he posted and you can see what you can do with it.


Top
  Profile  
 
 Post subject: Re: Any MS Excel gurus on here?
PostPosted: Sat Jun 21, 2014 3:13 pm 
Smithfield
Smithfield

Joined: Sun Jun 18, 2006 7:37 pm
Posts: 5538
I reread your example and put up a Google search on that just for funs.

I came up with this: http://exceltactics.com/combine-data-mu ... -one-cell/

Though this might not be what you're looking for, since it's combining cells that share a common attribute. Otherwise I used this search query https://www.google.com/search?q=excel+p ... +same+cell


Top
  Profile  
 
 Post subject: Re: Any MS Excel gurus on here?
PostPosted: Sat Jun 21, 2014 7:48 pm 
Little Foot
Little Foot

Joined: Thu Apr 03, 2014 9:34 pm
Posts: 122
Location: Portage, IN
I already know about Concatenate, and that is my alternative method that I am using. Though to use that I had to create another set of cells with validation lists for the list for the concatenate formula. I was trying to find a way to avoid making those extra validation lists. I used different search queries and could not find anything without the use of VBA, which is why I went to that excel forum. Thanks for the suggestion though.

Bruce


Top
  Profile  
 
 Post subject: Re: Any MS Excel gurus on here?
PostPosted: Tue Jun 24, 2014 10:54 am 
[Team Member]
[Team Member]

Joined: Sat Jun 26, 2004 4:31 am
Posts: 11117
Location: Home Sweet Home
Here is a forum I found for Excel:

http://www.mrexcel.com/forum/forum.php? ... ab1eb4f39b

Looks like you can ask any question under the sun and get an answer.

Nasty


Top
  Profile  
 
 Post subject: Re: Any MS Excel gurus on here?
PostPosted: Tue Jun 24, 2014 5:39 pm 
Little Foot
Little Foot

Joined: Thu Apr 03, 2014 9:34 pm
Posts: 122
Location: Portage, IN
Cool, that looks like a good forum. And it's free. I will see what they come up with.
Thanks Nastyman!
Bruce


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

© 2014 Future US, Inc. All rights reserved.