2 Worksheets, Different Headers - Move data from 1 sheet to the other my matching headers

[cmoon00]

Good Afternoon All,

Fairly new to VBA and looking for some help! I have a DATA sheet that is all of the information reported on a monthly basis. This format will never change, but the data will. I have a second sheet called MMUSAGE.

On the MMUSAGE tab, I have identified which headers (in red) from the DATA tab that correspond with the headers in the MMUSAGE tab. Question is: how do I move the data from the DATA tab over to the MMUSAGE tab under the appropriate headers?

Example: IF Product Number on Worksheet(DATA) = Product Code on Worksheet(MMUSAGE) then move all data to Column L.

I have attached a sample sheet for reference. Any help that can be provided would be appreciated!

[AB33]

Try the attached.

[cmoon00]

GENIUS!! Thank you SO much. Next question, is there anyway you might be able to verbally explain the code you wrote? I would like to have a general understanding just in case I run into errors and need to debug the code.

[AB33]

I do not know your knowledge and experience of VBA. The code is a bit complicated to explain if you are not familiar with scripting. PM me if you have any issue with the code.

[cmoon00]

Not a problem. Appreciate the help, thank you!