Matching and combining data out of 3 columns

**Tino XXL** · 01-26-2011, 04:39 AM

Hi fellow Excel users,

I have a small obstacle I can't get over.

In attachment you'll find a Excel workbook with two different layouts. The first area marked in red is the data I currently have. What I need the script to do is to copy everything in into column E but changing the matching and combining the data like you see in the green area. In the second sheet you'll find the code as I have it now, but somehow it mixes up the data.

Can you guys help me out?

Thanks in advance for all your help.

Greetz,
Tino XXL

**snb** · 01-26-2011, 05:06 AM

I don't get ge pattern between the columns, but simply use

Please Login or Register  to view this content.

**Tino XXL** · 01-26-2011, 05:14 AM

Originally Posted by snb

I don't get ge pattern between the columns, but simply use

Please Login or Register  to view this content.

Hi

I've only copied a part of the data I have.
This data is already extracted from a report I get on a daily basis. This report first provides me with a loading date (column 3), then it provides me with the references loaded (column 1) and at the end it provides me with the loading list number.

The script should actually match the references to the Loading list and actual loading date. But the layout has to be like marked in green since I'm running an additional macro on this info.

thx