I have two spreadsheets in Excel. One has a list of names and a blank column next to it for their respective jobs:
Lastname -- Job (blank)
The second spreadsheet has everyone's name (but with a title in front Ex. "OT Lastname") and then a column with everyone's job:
OT Lastname --...