Solved compare files in excel

March 20, 2019 at 10:42:06
Specs: Windows 7

I have 2 seperate workbooks that I have data in that I need to compare.

Problem is that at all times both workbooks will have different names but the 1st workbook will ALWAYS start with the name CUBIC/SHERE/FASTIS and then some numbers.

The 2nd workbook will always start with the name SDCI SUMMARY and again will have some numbers after.

Within the workbook called SDCI summary there are tabs called CUBIC/SHERE/FASTIS

What im trying to do is compare the data in workbook 1 against the tab with the same name as in cubic etc in the file called SDCI summary.

To make life easier I will open manually the 2 files that I want to compare and select the tab in SDCI summary file.

All columns on both workbooks have headers of which are NLC/MACHINE/DATE /AMOUNT

What im trying to do is look in workbook 1 and then look in tab in SDCI summary file(workbook 2 ) to see if there is a exact match. I need it to look all the way down the tab in the workbook called SDCI summary as data will not be in the same line in both workbooks.

If there is a match then that fine no action required, If there is NO match in SDCI summary (workbook 2) I need the row that dont match highlighted in the tab im comparing in SDCI SUMMARY.

Hope this makes sense.

See More: compare files in excel

Report •

March 20, 2019 at 11:48:26
✔ Best Answer
Here is an interesting web site that you might find useful:

I have never tried this, so would be interested in how it turns out for you.


Report •

March 20, 2019 at 13:21:14
Thanks for that.

Had a look and got wrong version of excel.

Report •
Related Solutions

Ask Question