Forum Discussion
aliaga_e
Aug 30, 2022Copper Contributor
Is there a way to use an excel tab to store others? not consolidating data
Hi,
Let me elaborate, I'm working on a file that has a "master sheet" and approximately 51 other sheets that draw data from it, and the number will keep increasing. Hence, I'm looking for a way to "store/group", not consolidate because the data is different in each sheet, these tabs in a single one to avoid clutter, so that, when i click this new tab/sheet it will show or hide the other ones.
And, if so, would this whole process interfere with the links I've putting in all sheets?
Best,
Euler
No RepliesBe the first to reply