Unhide hidden weeks and then re-hide all future weeks

[jconkl02]

I have a workbook with about 10 sheets that I use to create weekly charts based on incoming/outgoing tickets from the previous week. I have all of the past weeks visible and all of the future weeks (to EOY 2024) hidden. I want to be able to automatically unhide the most current week on each sheet. However, not all the projects started on the same week, so it's not as simple as unhiding the same batch of columns and then rehiding the future columns on each sheet.

11/22	11/29	12/6	12/13
20	30	9	40
21	25	22	30
47	52	39	49

 

[HighAndWilder]

Do I take it that you want to end up with columns in each of the 10 worksheets that represents the current week and all future weeks
visible and all columns that represent weeks prior to the current week hidden?

Is the Monday date always the one that is used to indicate the week in the column header?

Is the current week the week in which todays date sits?

 

[jconkl02]

Do I take it that you want to end up with columns in each of the 10 worksheets that represents the current week and all future weeks
visible and all columns that represent weeks prior to the current week hidden?

Is the Monday date always the one that is used to indicate the week in the column header?

Is the current week the week in which todays date sits?

Thanks for replying...

Actually, the only weeks I want visible are the current week and a running past 52 weeks. I want everything in the future and everything older than 1 year hidden.

Yes, the Monday date is always the week in the column header

No, I do this report for the week prior.

Also of note, and I apologize for not including this tidbit, the first worksheet is where my data is and doesn't get hidden/unhidden. Also, each worksheet represents a client and the goal is obviously to have more clients, so I would ask that the solution be scalable.

Thanks again for helping me out!.
Jason