Matching bulk data from two worksheeps to one.

[lilseymour04]

I am trying to compare deductions from two different pay periods. I have the Data from check 1 & check 2 on different worksheets, in no order, and would like the data to auto populate on a third worksheet into a side-by-side comparison of the data. The problem comes when there is a deduction missed or a new deduction that only shows up on one of the two checks. I am having to manually insert lines to make my side-by-side comparison match. Is there a macro or something that can pull the data from these two soures and display them in a side-by-side comparison even if there is no match? Any help would save me lots of time!!!

Thanks for your help!

[ARGK]

Hi
It would help if you could provide a sample with anonymised data of course.
Tony