VBA code to get checked values and put one below another in another column

**Anka** · 08-29-2012, 02:31 PM

This is basically a remodeling of a mine post , which I have not found the solution.
But this time I just want to know that:

If someone may be just explain me (please) how to do to get checked values and put one below another in another column (without blank cells), whit VBA code. .. It would be very helpful.
I do not want to use pivot tables or filters. Without macro. Just like in my example if possible.

Thank you in advance.

Anka

PS: I tried to adapt some formulas what I found here, but no chance. Fail.

**mike7952** · 08-29-2012, 02:55 PM

Try this I borrowed this from JBeaucaire. I believe it will work for you.

Uses a helper column

help.xlsx

**Anka** · 08-29-2012, 03:13 PM

OMG. So fast.
GREAT. It's exactly what I wanted.
It works great. Helper column is not a problem because it can be hidden.

Thanks a lot!

**mike7952** · 08-29-2012, 03:17 PM

Glad it worked for you, I'm not great with Excel worksheet formulas but I learned that today from JBeaucaire. So thanks to him too.

**Anka** · 08-29-2012, 03:21 PM

Great.

**Cutter** · 08-29-2012, 08:24 PM

Hello Anka, and welcome to the forum.

Great that you received the help you needed but unfortunately you have inadvertently broken one of the forum rules. Please read the following and keep it in mind for your future posts. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.