Best way to compare updated files

ac1223

New Member
Joined
Jan 9, 2024
Messages
7
Office Version
  1. 365
Platform
  1. Windows
I work for an Insurance company handling backloading of FMLA claims. When we receive a new customers list of Claims we currently get their initial file to load and then a month later we receive what is known as the final Load. The final load is usually everything that was in the initial load except with a few more claims. The issue is because the final load is EVERYTHING in the previous load, we usually have to go line by line and review every line between the two files to find the difference and see what was added, is there a better way to compare sheets? we also have to find updates in terms of absences. so, when we receive a claim on the initial load maybe the person was off 11/10 and 11/15, then we received the final load and now the employee also took off 11/25 and 11/27. These are all things at the moment I MANUALLY search for. Does anyone know of an easier way?

Apologies if I am not making sense.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
If your company has MSO365 Enterprise there is the "Spreadsheet Compare" tool:

Otherwise there are these options for example:
1. Commercial 3rd party software like
- Spreadsheet Compare (free trial) Download Spreadsheet Compare Tool to compare Excel files for differences
- Ablebits Excel Add-In Solve 300+ daily tasks in Excel with Ablebits Ultimate Suite
- Beyond Compare (free trial) Scooter Software | Home of Beyond Compare
2. Workaround with Excel built-in methods:
- create a Master Workbook, where you have three Sheets (a copy of the old data, a copy of the new data and a sheet which checks for equal cells

If you could provide a sample sheet (or an example with dummy data) with explanation and result, I may find a way.
 
Upvote 0
If you are interested in the Spreadsheet Compare tool @PeteWright mentioned, if your company has access to it will see it if you go to Manage: COM Add-ins (File > More > Options > Add-Ins > COM Add-ins), and check the Inquire add-in in the list that comes up.
There is a good list of what it can do here
 
Upvote 0

Forum statistics

Threads
1,224,241
Messages
6,177,370
Members
452,773
Latest member
D P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top