ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to compare two excell files ? (https://www.excelbanter.com/excel-discussion-misc-queries/129488-how-compare-two-excell-files.html)

TimR

how to compare two excell files ?
 
I have two address/name excel files. One is usually more up to date/current
than the other. Is there a way to have the most current excel file "read"
the older file and update ( i.e., replace the matching line/record in the
older file with data from the newer file ?

thanks, Tim



[email protected]

how to compare two excell files ?
 
Is xls format really required? If you could keep your data in csv,
this would be much easier. You can also convert both files to csv,
merge them with any comparison tool (like my own :) or free WinMerge),
and convert back to xls.

Igor Green
http://www.grigsoft.com/
Compare It! + Synchronize It! - files and folders comparison never was
easier!



All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com