Importing data into excel against one column
Posted on 2013-11-14
I'm trying to achieve the following scenario. I'd like to import data into excel against another column. E.g. column one is a "unique identifier". Say, for example, each staff member has a staff ID #. I'd like to import other columns "against" this column. So, if I have two spreadsheets I'd basically like to import one against the other, against column one. I want the import to look at the first column on spreadsheet #1, and if it finds a matching "unique identifier/staff ID" on the other spreadsheet I would like to import data for the other columns from that spreadsheet. Ideally I'd love to know how to 1.) Replace all data in spreadsheet 1 with the data in sheet #2. 2.) Replace only missing data in spreadsheet 1 with spreadsheet 2 (leaving on spreadsheet 1 that data that is already there).
I hope you can understand the question. Thank you, experts! If any clarification is need please let me know.