Change each weekday chart to a table. References will follow table name.
Formula in D14>> =INDEX(tblSunday[Travel Start],MATCH($C$8,tblSunday[[Employee Name ]:[Employee Name ]],0)).
Copy across for Sunday times.
Add a drop down list of employees and info will up date on form.
On my timesheet C8 is employee name.
|