I have spreadsheet "A" that lists 1400 employee's with their coresponding one of about twenty different OFFICE CODES. Have another spreadsheet "B" that defines the OFFICE NAME for each of the office codes. Would like to add the correct OFFICE NAME from "B" to each employee in "A". Can this be automated?
Bookmarks