Macro to combine data from multiple rows

Hi

I am new to the forums, but I have always been able to find what I need here, so I thought maybe someone could help me

I am trying to write a macro to combine data from multiple rows into one line of data. The worksheet is over 8000 rows long.

The raw data is pulled from 7 different worksheets, and I have been able to combine it down to two, three or four rows for each name - but the data I need could be on two or three of those rows, and not always the same ones. I have attached a small sample spreadsheet to show what it looks like at present, and what I need it to look like.

If there is a quicker way (ie non macro), I am also open to hearing about that.

Thanx guys

Tracy

Beni

You are my hero, not only does it do exactly what I need, but your quick response means I can finish this project tonight.

Thank you, thank you, thank you

AB33 - That does do what I want, but only on my test worksheet

When I run it on my 8000 row spreadsheet with full data, it doesn't do anything at all to the data.

I have amended code (#5). Please see if this works

AB33 - nothing has changed???

Try this

Please Login or Register  to view this content.