Dose for Excel ribbon
“Comparision” utilities » Compare Sheets
In the Excel menu choose: D-PRO  » Comparision » Compare Sheets

  1. Peer to Peer Comparision.
  2. Based on Column Comparision.




 
1. Peer to Peer.

  • Compare old and new sheets by peer to peer comparision will compare them row by row (ex: old sheet (row number 1) is compared to new sheet (row number 1)) and so on.
  • Options to set colors for update, new, removed rows and cells.
  • Option to insert comments in the new sheet to show the old value of the updated cells.
  • Option to show the Old / Updated data in the same cell.
  • Ability to compare between 2 external worksheets or current sheet in your workbook.
 
2. Based on Column.

  • Compare old and new sheets based on column, the comparision will look for each cell in the old sheet and look it up in the new sheet and vice versa then comparing the row data to show the changes. Below example is based on column (Name).
  • Options to set colors for update, new, removed rows and cells.
  • Option to insert comments in the new sheet to show the old value of the updated cells.
  • Option to show the Old / Updated data in the same cell.
  • Ability to compare between 2 external worksheets or current sheet in your workbook.
Up
Excel lower case
Excel Data Cleaning
Home

Copyright © 2014 - 2018 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Home
Compare Sheets
Compare Sheets
Up
Excel lower case
Compare Sheets
Compare Sheets