Combining two worksheets

[datadummy]

I have two worksheets that contain a common number along with accompanying data rows on each sheet, what I would like to accomplish is matching those common numbers from both sheets and bringing each set of accompanying data and merge it into one row. I am sure I will need to write a macro for this but am not versed in VBA, can anyone help out with this?

 

[hiker95]

datadummy,

It would help if we could see you actual raw data workbook/worksheets, and, what the results should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com