I searched the site but could not find an answer.
Here is what I need to do.
I have two separate workbooks with identical columns. The type of data is student ID, first name, last name, robe id, etc. One workbook is a master list and the other workbook is a secondary list containing some of the students (from the master list). All the students in the master list are eligible to be graduated. However, only those who attended the graduation appear in the secondary workbook (hence they rented the robe). In other words, all students in the secondary workbook will appear in the master workbook but the opposite is not true.
The column of interest is the one with "robe" heading. In the secondary workbook, all students have the "robe" id filled in (meaning all of them attended graduation and rented a robe). However, in the master workbook, only some students have the "robe" id filled in. It is possible that students who have rented the robe may appear in both the workbooks.
I would like to merge the "robe" column data from the secondary workbook into the master wrokbook so that the column identifies those who attended the graduation (or rented the robe) and those who did not.
My apologies if I failed to be much clearer than this. Your help will be much appreciated.
Gops