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.
Smitty - 02 Aug 2007 05:50 GMT
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
> 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.
Bernard Liengme - 02 Aug 2007 14:45 GMT
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

Signature
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
> 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.