Here we have an employee list spreadsheet with a column named Employee Name and a column named Employee ID . As soon as you enter a new…