Oct 25 2020 09:04 AM
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
Oct 26 2020 05:56 AM