title: VBA Excel : How to get the deleted row and added row in latest excel file while comparing with old file
body: <p>I am struggling with writing a vba code for getting the deleted rows data and added rows data in latest excel file while comparing with old excel file. </p>
  
  <p>example: latest workbook(WB) have 405 rows of data and old workbook(WB) have 400 rows of data. the factor is - <code>might have added 5 rows in latest WB</code> or <code>might have deleted 2 rows and added 7 rows in latest WB</code> . if it is added (row was added in latest WB), have to get the added rows data from latest WB, if it is deleted(the rows was deleted in latest WB), have to get the deleted rows data from old WB . Please help me.</p>