I would open up both spreadsheets and then merge the two using the VLOOKUP command. It works quite well for me.
Those directions can be annoying. I wrote the below up for my office.
VLOOKUP is composed of four components.
</ol>1a. W: What am I looking for as a reference point in the other spreadsheet, other tab, other area?
1b. This is a cell value (e.g. A2, C113, D6)
2a. R: This is range of data that will include both reference point and the value to be pulled back into the original sheet.
2b. This is a set column value which looks like $C:$F or a more specific range which is sometimes necessary when pulling data from different spreadsheets $C$2:$U$12000 (this means that the reference data is in column C between rows 2 and 12000 and the value to be pulled lies somewhere between cell C2 and cell U12000.
2c. The reference point to be matched MUST be in the first column listed here.
3a. C: This is a number which notes the number of columns to the right that the value to be pulled is from the reference point.
3b. If I wanted to pull the values 5 columns to the right, this would be the number 5.
4a. F: True of False.
4b. Do not ask me for the logic behind this one, but put false if you want your reference point “W” to be matched exactly to a value in rage “R”. Type true if you want it to search for similar if it cannot find exact.
4c. Type FALSE, it makes for clean data.
Good luck to you and let us know how it goes.