Thread: Excel 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Smitty Smitty is offline
external usenet poster
 
Posts: 43
Default 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.