Combining/merging multiple rows from one worksheet into one cell in another worksheet

Hi all

I'm trying to create a macro to merge multiple rows into one cell and display in a new worksheet.

This seems really simple but I've tried to re-work some other examples I've found online but none seem to do exactly what I need. I'm also pretty new to VBA , so it's highly possible i've missed something.

I need to display each set of Notes for each DonorNo in one row - with each note separated by a space.

I've attached a sample of the data and what I need for the output. In the actually file I have around 70,000 records so the prospect manually merging the rows is horrifying.

Does anyone have any suggestions?

Thanks

Try this:

Please Login or Register  to view this content.

My take on the same problem.

Please Login or Register  to view this content.

I use the font and size functions in the reply console. You have to GO ADVANCED to even see those options. It's actually a pain, not an improvement in functionality over the old setups that did that for us automatically.

Thanks.

Based on the OPs sample, blanks don't appear to be an issue, but doing an xlDown from the top of a dataset does occasionally bite you in the byte.

I always search UP from the bottom of the worksheet. The OPs example doesn't include blanks, but at least the macro would work even if it runs into them.

========
Badoody, if that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

It was designed from your original sample.

If some other sheet is failing, perhaps it is different in a way you didn't represent. If so, post it here.