Forum Discussion
weekly status report
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 no...
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:
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:
Say you want to filter all transactions from "CW2", press the triangle in the Week header and select "CW2"
to arrive at this:
Hello Riny, it's a very simple and effective approach. Thanks for your assistance, really appreciate it!
vins322021 You are welcome!
