Comparing two excel files

Closed
tt - Oct 20, 2010 at 09:08 AM
kumarapush123 Posts 1 Registration date Friday August 7, 2015 Status Member Last seen August 7, 2015 - Aug 7, 2015 at 04:02 AM
Hello,



to compare two excel files
first file look like this
MATRICULE DATEDP DATEFP
00970 20110112 20110112
01032 20101112 20101112
01032 20101110 20101110
01032 20101109 20101109

second file like this
MATRICULE DATEDP DATEFP
00041 13/09/2010 00:00 13/09/2010 00:00
00295 02/09/2010 00:00 02/09/2010 00:00
00278 13/09/2010 00:00 18/09/2010 00:00
00203 02/09/2010 00:00 02/09/2010 00:00

i like to check whether the DATEDP and DATEFP for a MATRICULE in the two files are correct , if erreur msgbox...
Related:

2 replies

Blocked Profile
Oct 20, 2010 at 12:21 PM
Hello,

Please get through the two below Kioskea FAQ articles in order to get free from the specific trouble that you are facing.

https://ccm.net/faq/6874-excel-compare-two-columns-and-delete-duplicates

https://ccm.net/faq/5278-how-to-compare-two-workbooks-worksheets

Thank you.
0
kumarapush123 Posts 1 Registration date Friday August 7, 2015 Status Member Last seen August 7, 2015
Aug 7, 2015 at 04:02 AM
The VBA Macro code in this article can be used to do a comparison of 2 Excel files.

https://officetricks.com/vba-macro-compare-two-excel-sheets-files-highlight-difference/

This macro code opens the excel files, read every cell in each Sheet, Verify the data and highlight if any data has a mismatch.
0