Compare and Merge Wookbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two Excel files which I want to Merge together on the cell PatientID
into another Excel file (Starting Empty). The tool box has a command 'Compare
and Merge Wookbooks' but is greyed out.
 
You can use that feature for workbooks that are copies of the same
shared workbook, and each must contain a change history. For details,
look for 'Merging workbooks' in Excel's Help.
 
I was able to complete the task by first taking the two Excel files and
saving as dbf Databases. Then in a blank worksheet I selected Select Data -
Import External Data - New Database Query. This displayed Choose Data Source
and I selected the two dbf tables. This then took me to Access which allowed
me to define the link between the two tables which I used PatientID. It then
merged the two tables into a single row containing data from both tables
creating a new mdb table. I then choose the Return to Excel which now has
Matching tables rows into one row in Excel.
 
Great! Thanks for explaining how you solved the problem. The information
may help someone else who's trying to do something similar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare and merge workbooks 4
Merge command not active 1
greyed out compare and merge document 3
How do i compare two different files 2
Merging Excel Files - Option "grayed out" 3
Compile data from several workbooks 1
How to paste photo into merged cell 1
Compare and Merge Workbooks 1

Back
Top