I'm looking to generate a script to allow automation of updating job titles using a spreadsheet.
To do this we would use a spreadsheet generated by another team called "UserExportSpreadsheet" (See attached for sanitized copy).
And basically if a user's job title in the spreadsheet is different from AD (using columns B and O in the spreadsheet for reference against EmployeeID and Job Title in AD).
We would run this command once a month using a scheduled task. But i'm looking for assistance with the proper scripting and in calling the file.
Please let me know if you require any additional information