ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel merge or synchronize (https://www.excelbanter.com/excel-discussion-misc-queries/177998-excel-merge-synchronize.html)

Bob

Excel merge or synchronize
 
I have a client with 2 Excel 2007 documents. Lets name then excel1 and
excel2. Now the client has always worked in excel1. Recently however the
client suffered a system failure and excel1 was lost. Excel2 is a backup copy
of excel1, but it hasnt been backed up for more than 2 months, thus 2 months
worth of information has to be redone.
Urgent work has to take place and the client starts adding current data to
excel2 from 2day, thus there is a month data gap in the file.
Thru the wonder of hard drive recovery I was able to recover excel1 today.
Is it at all possible to merge or synchronize excel1 and excel2 with each
other so that one of them is completely up-to-date?


David Biddulph[_2_]

Excel merge or synchronize
 
There's no automatic way of doing this. You'll need to look at the data
structure and decide which parts from which file you need, then do copy and
paste.
--
David Biddulph

"Bob" wrote in message
...
I have a client with 2 Excel 2007 documents. Let's name then excel1 and
excel2. Now the client has always worked in excel1. Recently however the
client suffered a system failure and excel1 was lost. Excel2 is a backup
copy
of excel1, but it hasn't been backed up for more than 2 months, thus 2
months
worth of information has to be redone.
Urgent work has to take place and the client starts adding current data to
excel2 from 2day, thus there is a month data gap in the file.
Thru the wonder of hard drive recovery I was able to recover excel1 today.
Is it at all possible to merge or synchronize excel1 and excel2 with each
other so that one of them is completely up-to-date?




Alan[_10_]

Excel merge or synchronize
 
On Feb 27, 4:04*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
There's no automatic way of doing this. *You'll need to look at the data
structure and decide which parts from which file you need, then do copy and
paste.
--
David Biddulph

"Bob" wrote in message

...



I have a client with 2 Excel 2007 documents. Let's name then excel1 and
excel2. Now the client has always worked in excel1. Recently however the
client suffered a system failure and excel1 was lost. Excel2 is a backup
copy
of excel1, but it hasn't been backed up for more than 2 months, thus 2
months
worth of information has to be redone.
Urgent work has to take place and the client starts adding current data to
excel2 from 2day, thus there is a month data gap in the file.
Thru the wonder of hard drive recovery I was able to recover excel1 today.
Is it at all possible to merge or synchronize excel1 and excel2 with each
other so that one of them is completely up-to-date?- Hide quoted text -


- Show quoted text -


You may try a popular Excel file recovery tool called Advanced Excel
Repair to repair your Excel file. It is a powerful tool to repair
corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope this will help.

Alan


All times are GMT +1. The time now is 05:37 AM.

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