Previous Topic Next Topic

Comparing two excel files

Closed
tt - 20 Oct 2010 à 09:08
kumarapush123 Posts 1 Registration date Friday 7 August 2015 Status Member Last seen 7 August 2015 - 7 Aug 2015 à 04:02
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 responses

Réponse 1 / 2
Blocked Profile
20 Oct 2010 à 12:21
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.
Réponse 2 / 2
kumarapush123 Posts 1 Registration date Friday 7 August 2015 Status Member Last seen 7 August 2015
7 Aug 2015 à 04:02
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.