weekly status report

%3CLINGO-SUB%20id%3D%22lingo-sub-2234701%22%20slang%3D%22en-US%22%3Eweekly%20status%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2234701%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EDear%20All%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EOn%20a%20weekly%20basis%20I%20create%20a%20weekly%20status%20report%20with%20all%20the%20daily%20activities%20completed%20at%20work.%20Every%20microsoft%20excel%20tab%20corrisponds%20to%20a%20week%2C%20ie%3A%20CW01%2C%20CW02%2C%20CE03%2C%20CW04%2C%20etc.%20I%20am%20now%20asked%20to%20only%20use%20one%20sheet%20with%20a%20column%20where%20it's%20possible%20to%20filter%20all%20the%20different%20weeks%20(CW01%2C%2002%2C%2003).%3CBR%20%2F%3ECould%20anyone%20please%20help%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2234701%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2234750%22%20slang%3D%22en-US%22%3ERe%3A%20weekly%20status%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2234750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F977442%22%20target%3D%22_blank%22%3E%40vins322021%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recommend%20that%20you%20include%20an%20existing%20file%20%2F%20workbook%20(without%20sensitive%20data)%20in%20order%20to%20come%20up%20with%20a%20suggested%20solution%20that%20might%20suit%20you.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAt%20the%20same%20time%2C%20you%20facilitate%20the%20work%20of%20those%20who%20want%20to%20help.%20why%20does%20one%20of%20the%20helpers%20also%20want%20to%20finish%20the%20file%3F%3C%2FP%3E%3CP%3ECan%20only%20offer%20help%20to%20help%20yourself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20like%2C%20you%20can%20use%20this%20link%20to%20download%20the%20templates%20that%20Microsoft%20provides%20free%20of%20charge.%20Maybe%20one%20of%20the%20existing%20ones%20will%20fit.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftemplates.office.com%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help%20with%20this%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Dear All,
On a weekly basis I create a weekly status report with all the daily activities completed at work. Every microsoft excel tab corrisponds to a week, ie: CW01, CW02, CE03, CW04, etc. I am now asked to only use one sheet with a column where it's possible to filter all the different weeks (CW01, 02, 03).
Could anyone please help?

Thank you!

4 Replies

@vins322021 

I recommend that you include an existing file / workbook (without sensitive data) in order to come up with a suggested solution that might suit you.


At the same time, you facilitate the work of those who want to help. why does one of the helpers also want to finish the file?

Can only offer help to help yourself.

 

If you like, you can use this link to download the templates that Microsoft provides free of charge. Maybe one of the existing ones will fit.

https://templates.office.com/

 

I would be happy to know if I could help with this information.

 

Nikolino

I know I don't know anything (Socrates)

 

@vins322021 Start by copying and pasting your weekly transactions into one sheet leaving no empty rows between the weekly data. Add a column called "Week" where you enter the week reference that you had given to the weekly tabs. It might look like this:

Screenshot 2021-03-25 at 13.15.40.png

The filter buttons in the header row are created by using the Sort & Filter icon on the Home ribbon while the active cell is anywhere in the list. Like so:

Screenshot 2021-03-25 at 13.15.23.png

Say you want to filter all transactions from "CW2", press the triangle in the Week header and select "CW2"

Screenshot 2021-03-25 at 13.22.45.png

to arrive at this:

Screenshot 2021-03-25 at 13.16.09.png

 

 

@Riny_van_Eekelen

 

Hello Riny, it's a very simple and effective approach. Thanks for your assistance, really appreciate it! 

@vins322021 You are welcome!