Thread: Need To Compare Two Worksheets, Update Current Records And Insert New
View Single Post
 
Old 06-29-2012, 02:27 PM
David92595 David92595 is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Jul 2011
Posts: 4
David92595 is on a distinguished road
Default Need To Compare Two Worksheets, Update Current Records And Insert New
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
Reply With Quote