Forum Discussion
bencharnock
Oct 25, 2020Copper Contributor
auto-filling a table from another table
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 t...
JKPieterse
Oct 26, 2020Silver Contributor
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.