Hello,

I'm using Excel 2007

I have two reports (last months report and this months report) that I need to compare. If the account number is the same I need to compare two columns on each worksheet and if it they have changed update the two cells on sheet1. If the account number is new I need to add the whole row to sheet1 from sheet2.

Let me know if I'm missing any needed information.

A macro would be preferred, but I'll take what ever advise I can get.

As always all any help is greatly appreciated,

David 92595