I have a file which currently contains 15 tabs with data that I want to filter and show on a summary tab. I have been able to accomplish this with an ugly formula...
It works but if there is a new tab added, then I have to manually update the formula when I would rather update the list of tab names. What I want to do is have a list of tab names, dynamically build the FILTER formulas, and then wrap a VSTACK around it. Sort of like VSTACK( B3, B4).
Here is how I created the individual FILTERs...
How can I do this?
It works but if there is a new tab added, then I have to manually update the formula when I would rather update the list of tab names. What I want to do is have a list of tab names, dynamically build the FILTER formulas, and then wrap a VSTACK around it. Sort of like VSTACK( B3, B4).
Here is how I created the individual FILTERs...
How can I do this?