Macro to concatenate cells

Hi, I've been stuck for a few hours with merging data from different cells into one. Now, I know how to do this by useing a formula, but im looking for a vba solution.

I have data generated by a macro in Cell E3 to E50. Depending on user input, cells can be blank (a macro is allready sorting the cells with data up. So its possible that only cells e3:e5 have a value. or depending on input cells e3:e15 have a value)

	E
3	test 1
4	test 2
5	test 3

Now I would like to merge that input in cell E1 like this:

	E
1	test 1 test 2 test 3

So each piece of data on a new line.

Im new with macro's etc., so be gentle with me

Hope someone can help

Hi Arlu,

Thank you for your reply.
The criteria is that if cells in the range e3:e20 have a value, it needs to merge those values in cell e1 (and each value on a new line)

isolating this particulair bit from the rest of my (massive) project will be quite a challange, so the sample file I can provide would be very basic..
Not sure if that would be of use for you. But ok, attached

Regards,
Steven

Hi Steven,
maybe so

Please Login or Register  to view this content.

Please Login or Register  to view this content.