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?