Excel 2003
 

My wife and I keep a copy of our inventory on each of our computers.
My problem is we have both entered data on our own computers.
Can we merge the two files and not loose any data?
And how would we go about it.

Excel 2003
 

Welcome!

Without seeing your setup, I'd imagine copying one wb and opening it
(renamed) on the other PC, then append all of the data to the other one. If
you have a master record identifier you can sort on, you can then delete
duplicates or seach the MSKB for a "delete duplicates" code snippet.

If you have a home network I'd suggest setting up the master as a shared
workbook; then you can both work on it at the same time with *essentially* no
duplication (see the hekpfile for "limitations of shared workbooks").

HTH,

Smitty

"CNC Diag" wrote:

My wife and I keep a copy of our inventory on each of our computers.
My problem is we have both entered data on our own computers.
Can we merge the two files and not loose any data?
And how would we go about it.

Excel 2003
 

Hopefully you have the same format
Make backup of both files
Copy and paste your data to wife's worksheet
Then remove duplicates
Start by looking a Chips stuff on duplicates at www.cpearson.com
Then set up a home network: ONE set of Data belongs in ONE database
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"CNC Diag" <CNC wrote in message
...
My wife and I keep a copy of our inventory on each of our computers.
My problem is we have both entered data on our own computers.
Can we merge the two files and not loose any data?
And how would we go about it.