Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
gedcom files in excell Bob Excel Discussion (Misc queries) 3 December 18th 06 06:28 AM
Sharing read-write Excel 2003 files ttt8262 Excel Discussion (Misc queries) 0 April 1st 06 10:39 PM
can you single click to open files in word and excell? lvinning Excel Discussion (Misc queries) 5 April 26th 05 01:40 AM
IS there a way to compare 2 excel files PeterM Excel Discussion (Misc queries) 4 April 7th 05 04:47 PM
Cannot access read-only documents. tomgillane Excel Discussion (Misc queries) 14 February 7th 05 11:53 PM


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"