Tables across sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2260106%22%20slang%3D%22en-US%22%3ETables%20across%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2260106%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20probably%20a%20very%20simple%20question%20but%20I'm%20not%20really%20an%20excel%20guy.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20creating%20a%20log%20of%20work%20done%20by%20contractors.%20Very%20simple%20just%20name%2C%20who%20contracted%20them%2C%20date%20%2C%20hours%20worked.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20all%20fine%20and%20dandy%20but%20I%20also%20need%20to%20be%20able%20to%20break%20it%20down%20by%20month.%20So%20they%20worked%20X%20amount%20of%20hours%20per%20month.%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20what%20I%20setup%20is%20a%20workbook%20with%20worksheets%20for%20each%20month.%20I%20can%20input%20data%20into%20these%20and%20it's%20easy%20enough.%20What%20I%20would%20to%20create%20though%20is%20like%20a%20yearly%20sheet%20where%20I%20can%20see%20for%20the%20year%20all%20the%20contractors%20and%20hours%20worked%20etc.%20So%20I%20was%20hoping%20I%20could%20just%20copy%20a%20table%20to%20that%20sheet%20for%20each%20month%20but%20feels%20really%20clunky.%20It%20would%20also%20be%20good%20for%20it%20to%20only%20pull%20the%20cells%20with%20information%20in%20it%20rather%20than%20all.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20input%20or%20help%20on%20this%20probably%20basic%20question%20would%20be%20much%20appreciated.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2260106%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hi

This is probably a very simple question but I'm not really an excel guy.

I'm creating a log of work done by contractors. Very simple just name, who contracted them, date , hours worked.

This is all fine and dandy but I also need to be able to break it down by month. So they worked X amount of hours per month.

So what I setup is a workbook with worksheets for each month. I can input data into these and it's easy enough. What I would to create though is like a yearly sheet where I can see for the year all the contractors and hours worked etc. So I was hoping I could just copy a table to that sheet for each month but feels really clunky. It would also be good for it to only pull the cells with information in it rather than all.

Any input or help on this probably basic question would be much appreciated.

Thanks.
1 Reply

@Constiel If I were you, I would stick to the one-list approach. The worst thing to do is start creating monthly sheets. Excel is very good at taking big quantities of structured data and then summarise or reorganise it in seconds.

 

Begin by looking into Pivot Tables. There are many tutorials on-line and they are not very difficult to learn to work with. If needed, come back here with a file containing your data (remove any private and confidential information though), and I or someone else here can help you further.