vba matching columns of data and copy/pasting to new row on different sheet

Your attached file is not visible.

Also, if i understand your problem correctly, vlookup can help you out to get the information you need. However, i can say for certain once i have a glance at your attachment.

Ok, sorry! I'll try again, thanks.

Basically I need to copy and paste the data from "All Data" into "Collated Data" so that all the information for each participant is all on one line, rather than underneath each other.

The problem is there is a different amount of data lines for each participant.

Your help will be greatly appreciated.

Thanks

I have this code for you which works when i tested it. Let me know if you face any problems.

Please Login or Register  to view this content.

P.S - When i tried to understand your problem, it did look pretty tough to convert into VBA. But when it was finally done, i didnt expect it to be that easy.

It worked perfectly. Thanks so much for you help. This will save a lot of time.

Cheers again!

Thanks so much for your previous help. I am now trying to modify the code in order to do the exact same thing, but for another set of data, but I am running into the problem that it only does the first line and doesn't keep going. Which part of the text am I meant to modify to get it to go to next line?

I have attached my workbook and here is the code.

Your help is greatly appreciated!

Please Login or Register  to view this content.

You have some merged fields there which are creating problems in the cell referencing. Change the 1st 2 lines to the below :

Please Login or Register  to view this content.

Thanks heaps, that fixed it.

Cheers