Hello,
I have 2 separate spreadsheets:
1. List of employees with their current user ID, First Name, Last Name, Phone Number and Extension.
2. List of employees with their current user ID, First Name, Last Name and NEW phone number and NEW extension.
I need to update spreadsheet 1 with the new phone number and extensions from spreadsheet 2 based on the unique identifer of the employee user ID.
We are installing a new phone system and I need to be able to update the employee directory.
I have attached 2 sample files of what my data looks like, any help is greatly appreciated.
Thank you,
Sue
Bookmarks