I have two Excel spreadsheets that have the same columns, but different rows and different values for the corresponding cells.
Is there an easy and free way to merge the data?
Data is not numbers that need it be added, it’s text like names, addresses, phone numbers, etc.
Thanks.
You can use the VLOOKUP function
Excel/Merge column data from two spreadsheetshttp://en.allexperts.com/q/Excel-1059/2009/4/Merge-column-data-spreadsheets.htm
Thanks hal4.
The VLOOKUP wasn't quite what I was looking for, I'll give JMC a try later on one the trial for the DigDB plug in expires ;)
Thanks hal4.
The VLOOKUP wasn't quite what I was looking for, I'll give JMC a try later on one the trial for the DigDB plug in expires ;)
try these guides :
http://office.microsoft.com/en-us/excel-help/consolidate-data-in-multiple-worksheets-HP010095249.aspx
http://msdn.microsoft.com/en-us/library/cc793964%28v=office.12%29.aspx
http://www.accountingweb.co.uk/anyanswers/how-do-i-combine-worksheets-excel
http://support.microsoft.com/kb/211802
This microsoft help is about joining two files...
so you can move the data of your spreadsheet to a file and then merge both the files.
you just have to go to second spread sheet and save it as a new file.
http://www.digdb.com/excel_add_ins/join_merge_tables_lists/
JOINING TWO TABLES. you will have to move data of second spreadsheet to a table.
Thank you, Jay.
The guides didn't do what I was looking for, but the plugin did it. Now I have one master file.