Hey there. There certainly is. You just have to add the new sheet and make sure you place the new sheet in between the current range of sheets you have selected.
IMHO this is a rather stupid Excel centric solution looking for a problem :-( The root problem here is bad data design. Put all your members in a _single_ sheet and you can query it any way you want on a second sheet using ANY property now or for future extensions. Complete waste of time and bandwidth...
great one, thank you for sharing
Hi there. Thanks for liking it and making a comment.
thank you for the explanation!
No problem, this formula is a really handy one! Thanks for the message.
Wow. Thank you for sharing
Hey hey, no worries. Thank you for leaving a comment
I think for the filter of non blank data, it should be A2:A1000 or similar as the total rows from Vstack combine may exceed 100
Good advice. Thanks
What if the data in the tabs were transformed into a table? Would VSTACK function work itself instead of nesting?
Is there the ability for the the formula to add in any sheets added? As the data grows to the next month? Without having to manually go and edit it
Hey there. There certainly is. You just have to add the new sheet and make sure you place the new sheet in between the current range of sheets you have selected.
IMHO this is a rather stupid Excel centric solution looking for a problem :-(
The root problem here is bad data design. Put all your members in a _single_ sheet and you can query it any way you want on a second sheet using ANY property now or for future extensions.
Complete waste of time and bandwidth...