Need advice on how to merge two Excel spreadsheets
Posted on 2007-07-24
I have an Excel spreadsheet that has all the information I need for a project, other than one piece. That piece of information is on a separate spreadsheet. Column A on spreadsheet one has the same values as column A on the spreadsheet two, though not in the same order, and there are many rows on spreadsheet two that aren't required on spreadsheet one. Column A is the only one where the two spreadsheets contain common values.
I am not proficient with Excel and haven't been able to figure out how to merge the two. I need a way to have column A on both spreadsheets matched so the values from column F will appear on spreadsheet one, in the correct rows.
Apologies if this doesn't make sense, and please let me know if more information is needed.