I have two spreadsheets with similar data (Last Name, First Name, User ID). One spreadsheet has the two name fields separated into two columns, while the other has them combined into one (Lastname, Firstname). The first spreadsheet doesn't have the UserID field populated. I need to compare the records between the two spreadsheets and update the UserID from SS2 to SS1 where a match is found.
  • How do I link the two spreadsheets?
  • How do I perform the comparison between the first and last name fields, being that they are record in two columns in SS1 and a single column in SS2?
  • When a match is found between spreadsheets, how do I copy the UserID from SS2 to SS1?

I have not scripted Excel before, so this is a totally foreign task for me. Thanks.