Reading data from columns

[pine89fcb]

Hello,
I have a macro problem where I would be reading data into columns. The macro would copy the data into designated columns. the macro would work on approximately 10,000 lines of data. It's best to describe the macro model in the example tab and thank you in advance for your help.

[jomaor1]

Hi,

Have you tried doing with a simple VLOOKUP?

You can surely do your Macro copy and paste only values so your workbook doesn't get super heavy,
but you mainly would just use a simple VLOOKUP just like the attachment

Don't forget you'll need to add a "Concatenated Column" on the other Sheet.