ANmarS - Portfolio - Compare2

Excel/VBA expert since Sep 1997 (19 years 6 months)

Compare2    Added: 8/28/2012 | Created: 8/28/2012   



Same like Compare2Sheets, this file will compare between two sheets in formula/functions method.
As for the earlier version (Compare2Sheets) this one needs to have the full folder locations, file names and sheets names for both file1 and file2. Then once these files are open, the sheet will be updated with comparison results, showing that every cell is checking for its equivelant addresses from both sheets in both files.

  • If cell in 'Compare' worksheet is blank, it means both equivelant cells in the two worksheets are blank.
  • If it is green 'Y', that means they are identical in value.
  • If it is red 'N', it means they are not equal/

This one is more simplified than Compare2Sheets, and more direct to the point.


Download (9.5 KB)

1079 downloads | Last updated: 1/15/2014


Screen shots (5)