Excel 2007 : Reconciliation Query Excel 2007

Hello -

To give a little back ground. I am pulling data from 3 seperate reports. (Sol 1, Sol 2, Sol 3 see attached). My goal is to make sure the order # and dollor amount match in Sol 1 & Sol 2 and the order number shows up in Sol 3). I can easily import each one into Excel.

Sol 1 - Shows the Order # but spilts out the order into seperate lines (added together will equal Sol 2, if there are multiple lines on an order)
Sol 2- Shows the Order # and the total amount of the order (That will equal Sol 1).
Sol 3 - Shows the Order #, Commision Amt, and when the order was placed.

I am trying to compare each report side by side to make sure it flows from one system to another and the final report (sol 3) showing the commission amount. We have been running into problems where data from Sol 1 (where the order is created & originates) does not show up on Sol 2 & Sol 3. The IT folks are looking to fix this, but I need to find a better way to show where orders are missing. Right now I am creating the attached and manually looking across the rows to make sure Order # xxx shows up in all 3 columns (and of course the dollar amount matches in Sol1 & Sol 2). Verifying the commision amount will be a seperate task.

I am just not sure what the best route to take on this.

Appreciate any input.

Jason

Good morning,

Yes all three reports are seperate workbooks. What you are looking at is the manual cutting and pasting into one workbook. Does your code allow for the 3rd report as well?.

Thanks