How to pull values from a column, and list them in a cell

Native Excel functionality has no elegant way to concatenate values from multiple cells into a single cell without using VBA.
Is this an absolute requirement or a "would be nice"?

Perhaps something like this....

Please Login or Register  to view this content.

Is that something you can work with?

After adding the code I posted into a general VBA module in your workbook, use this formula in your worksheet:
C1: =concattext(A2:A8)

Using your sample data, that formula returns: Q1, Q4, Q5, Q6

Does that help?

• Activate your workbook
• ALT+F11...to open the VBA Editor
• Insert.Module
In the new module for that workbook...
• Copy the code I posted
• Paste it into the new module
In the workbook, on any sheet...
• Enter this in a cell:
=concattext(...select the range of No Input cells....)
...so if the data is in Sheet1!A2:A10...then this is the formula: =concattext(Sheet1!A2:A10)

Does that help?

Originally Posted by Naja

Now it is working!!
Btw if i may ask, how did you learn to write such VBA codes? By experience? Classes? Books?
What do you recommend me to do?

• Start with whatever style of VBA book facilitates your learning.
• Get involved in a large VBA project.
That one is important...Large, complicated projects punish you mercilessly for any ineffecient coding approaches, guaranteeing that you learn to only produce clear, efficient, well-documented, manageable programs.

1) Programming books are written in a few different styles. For example, some books create a story and build on it while others may divide VBA topics into functional groupings and devote chapters to each. You may also find some good on-line tutorials/videos. Browse likely candidates for the one you think you'll learn best from. In the end, you'll learn the same information.

2) That macro happened to take me around a minute to create.