Forum Discussion
Macro to change sheet displayed
Would it be possible to have one sheet that can be used to display any of the other sheets upon selection or command?
It would be a case of clearing its current contents and then pulling everything from another sheet, I think? Then the other sheets could be hidden.
Yes, that's possible. The INDIRECT function can do it. Depending on how those sheets are arrayed, FILTER could also work.
Sadly, without a better understanding of how your sheets are laid out (designed) it's hard to give more specific info. Is it possible, without disclosing confidential information, for you to post a copy to OneDrive or GoogleDrive and a link here granting access?
In general (again without seeing the existing design, hard to be certain) it probably is the case that the entire workbook could work FAR more efficiently if the separate monthly sheets were combined into a single database. It's a fairly common mistake for people unfamiliar with some of Excel's abilities to design workbooks as if they're still working with paper ledger sheets; in the latter (former) case, it made sense to keep months on distinct sheets; in Excel that practice actually gets in the way, making reporting--such as you're wanting to do now--more difficult.
Thanks for the reply! Yes I'll make a copy of the file without anything confidential and post here asap.
My preference is to have a database that can then be visualised in powerbi but it's a request for it to be like this in spreadsheets unfortunately so it's out of my hands.
But I have permission try to clean it up as best as possible for consumption