title: Trying to find particular data in one Excel spreadsheet, transfer it to another Excel spreadsheet
body: <p>I have 2 spreadsheets in excel.  "Spreadsheet A" has ~ 1000 rows- each a different patient. "Column A" w/ name of patients and then "Column B" w/ age, "Column C" with medical record number etc.  I am adding new data to "Spreadsheet A"- tumor size in "Column BR").<br>
  "Spreadsheet B" has about 80% of the patients from "Spreadsheet A" (plus about 500 others).  It also has the tumor size data.  I am looking for a way to search by name ("Column A") for the patients in "Spreadsheet A" in "Spreadsheet B", and then when it finds a patient that is in both Spreadsheets, automatically insert the tumor size in "Column BR" in "Spreadsheet A" from "Spreadsheet B".</p>