...

Prepare grad data within "master" spreadsheet

Add "Grad" to title of each person in the "grad" spreadsheet.

Cut-and-pasted people data from "grad" spreadsheet into "master" spreadsheet (columns A-E)

Paste below faculty data so that data is not over-written.

Cut-and-paste email addresses from NetID column (D) to Email address column (H).

...

Current_Faculty201308_oh10

Copy previous "master" list as a template for the new master list.

Delete all but faculty entries

...