|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
10-31-2022, 11:46 AM
|
|||
|
|||
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. 
|
|
|
| Tags |
| bulk copy paste, formulas, reference |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to create a block text and when click on the title of block hide and unhide the block | labasritas@free.fr | Word | 4 | 09-17-2017 01:17 PM |
 Does Excel have a way of using variables to easily update reference formulas?
|
Lluewhyn | Excel | 1 | 10-19-2016 07:59 AM |
|
large workbook needs restarted every month with deletions and resort without losing formulas
|
llhail | Excel Programming | 1 | 06-02-2015 05:34 PM |
|
Formulas/Scripts That Cross Reference & Import Data
|
ekeithjohnson | Excel Programming | 3 | 08-23-2014 11:26 PM |
| Losing rows when pasting split cells | Gitley | Word Tables | 1 | 01-15-2013 07:49 AM |
Windows 10 
Office 2010
Hybrid Mode