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.
|