Need To Compare Two Worksheets, Update Current Records And Insert New

[David92595]

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

[Catalin.B]

Without a sample of your data, to see how data is organized, you will not get a response... as you already noticed. Be generous on details, so you will not be the only one to know what you need, you will get a much faster response...