Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

Excel 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CNC Diag - 02 Aug 2007 02:04 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.