auto-filling a table from another table

%3CLINGO-SUB%20id%3D%22lingo-sub-1816208%22%20slang%3D%22en-US%22%3Eauto-filling%20a%20table%20from%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816208%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20get%20a%20table%20to%20show%20how%20workers%20hours%20are%20allocated%20between%20different%20locations%20and%20doing%20the%20different%20jobs%20at%20each%20location.%20If%20you%20look%20in%20cell%20B202%20of%20the%20'October'%20tab%20I%20have%20a%20table%20in%20which%20I've%20copied%20and%20pasted%20a%20few%20of%20the%20day%20'input'%20tables%20which%20get%20filled%20in%20day-to-day%20(e.g.%20Friday%20starting%20in%20cell%20T5).%20In%20my%20first%20week%20I%20added%20a%20date%20column%20as%20it%20was%20something%20I%20was%20experimenting%20with%20-%20I%20don't%20know%20if%20it%20will%20help.%20The%20table%20in%20B202%20outputs%20the%20pivot%20table%20in%20K206%20which%20is%20the%20ultimately%20desired%20table.%20Is%20there%20a%20way%20to%20automatically%20update%20B202%20with%20my%20inputs%20in%20the%20per%20day%20tables%3F%3F%20Or%20is%20there%20a%20better%20way%20of%20getting%20a%20table%20such%20as%20that%20in%20K206%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1816208%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1818448%22%20slang%3D%22en-US%22%3ERe%3A%20auto-filling%20a%20table%20from%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818448%22%20slang%3D%22en-US%22%3EIt'd%20be%20a%20lot%20easier%20if%20you%20would%20create%20just%20one%20table%20with%20source%20data%20with%20new%20rows%20for%20each%20person%20per%20day%20and%20a%20separate%20date%20column.%20Then%20you%20can%20use%20a%20pivot%20table%20based%20on%20that%20single%20table%20to%20view%20summaries%20of%20the%20data.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 

1 Reply
Highlighted
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.