I would like to get a table to show how workers hours are allocated between different locations and doing the different jobs at each location. If you look in cell B202 of the 'October' tab I have a table in which I've copied and pasted a few of the day 'input' tables which get filled in day-to-day (e.g. Friday starting in cell T5). In my first week I added a date column as it was something I was experimenting with - I don't know if it will help. The table in B202 outputs the pivot table in K206 which is the ultimately desired table. Is there a way to automatically update B202 with my inputs in the per day tables?? Or is there a better way of getting a table such as that in K206
It'd be a lot easier if you would create just one table with source data with new rows for each person per day and a separate date column. Then you can use a pivot table based on that single table to view summaries of the data.