Returning unique values as a string of text

[beth777]

Hello,
I have a spreadsheet with multiple tabs and on the first "summary" tab, I would like to return all unique values for a specified range of cells on each tab -- but keeping them listed in one single cell. So far, I've only been able to find how to do this by creating a combo box. Is there a way for these values to appear as a string of text? I am just setting up the spreadsheet, so there is no data populated yet, so the formula will need to be dynamic and update automatically as users enter information on the tabs.

Please let me know what other information I can provide that might make this question more clear.

Thanks,
Beth

 

[GlennUK]

I think the question is clear, it's just that you are wanting to do something that can only be done with VBA ... how are your VBA skills? And why are you wanting to do this ... having results appear a string of text in a single cell ... it's not the way data or results are usually organised in Excel.

Can you try writing something yourself, or are you a complete beginner?

 

[GlennUK]

Someone asked for something very similar:

http://www.mrexcel.com/forum/showthread.php?t=538079

... with a solution given.

 

[beth777]

Thanks for the pointer, I will check that solution out and try to apply it to my problem. I have very limited experience with VBA, mostly I can follow instructions and copy & paste what others tell me to do!

The reason for wanting it this way is for a quick reference at what information appears in the other spreadsheets, without the users needing to click around. The values in the list represent software bug identifiers, so this will show them at a glance which bugs are open (and then detailed information on each tab if they care to dig deeper.)

Thanks again!