Organizing columns

[Lancer7]

Hello, I have a Workbook with several sheets of information all somewhat related and utilizing information for formulas from one another, In each sheet I have several years of information so for example 2020 column A through column CB, Then 2021 is the exact same information but column CC through DP, and so on throughout the years. Currently I group columns and hide them and just leave the current year open so I dont get "Lost" in the wrong years. Wondering if there is anyway to make tabs, Or I know there isn't "subsheets" but I'm looking for a similar idea or any idea of some way to organize my sheets where I can click a button and get to a certain year

 

[Jeffrey Mahoney]

A macro could be created to hide columns based on dates in cells. Since you have 80 columns per year, it seems like a better option to put each year on its own sheet. Navigating to a sheet is easy. You're hesitant to put each year on a sheet because you have summary formulas for all years; that can be overcome.

Jeff

 

[Lancer7]

I'm more worried that my spreadsheet already has 10 sheets and as I keep working on the spreadsheet I am sure it will grow, and each of those sheets has a similar problem where they all have several years, So my tabs would just become complicated as Id end up with like 100 sheets

 

[Jeffrey Mahoney]

So, Provide a snippit of your worksheet. I could create a macro that enables you to select the year you want to display using a pulldown, and then boom, all columns are hidden except for the one you need.