How to hide columns based on date (Weekly, Monthly,Quarterly)

[Renaliiii]

TemplateExample.xlsx

****Created a generic template of what I'm trying to show***

I am creating a cumulative total data sheet for an employee incentive program. I posted previously but may have been wayyyy overthinking the issue at hand.


What I'd like to do is this.

Employee: WEEK1: WEEK2: WEEK3: WEEK4: MONTH1: MONTH2: MONTH3: QUARTER1: QUARTER2: YEAR
John
Jim
Jan
Joe


Where the user inputs a number for weekly total into the column for the current week (I may actually have this inputting from another page on the worksheet automatically if I can) , while no other weekly columns are shown(Need excel to find current week and display only that column). Then add weeks pertaining to current month together and display only the current months total, I would also like to display the current quarter totals, and then show the cumulative yearly total.


Id like to just hide the weeks/months/quarters outside the current so that I may go back in case of audits or any questions about the totals.

Is this possible? If someone wanted to make a dummy worksheet with this inputted I'd also be forever grateful.


Thank you

[Fotis1991]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.