Forum Discussion

aliaga_e's avatar
aliaga_e
Copper Contributor
Aug 29, 2022

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