View Single Post
 
Old 10-31-2022, 11:46 AM
mrgramm mrgramm is offline Windows 10 Office 2010
Novice
 
Join Date: Jan 2020
Posts: 7
mrgramm is on a distinguished road
Default

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.
Reply With Quote