Structured reference for all tables that start with...

Copper Contributor

I may not be doing this the right way but I am trying to create a set of tables that can be duplicated without having to change some hidden COUNTIF functions that I am using in their columns. I noticed that as the tables are duplicated they share the same name but appended with a new number (Table1, Table2, Table3...).

 

Is there a way I can make that function auto-add a table to the function as it is copied? Is there a way to reference all tables that start with a certain naming convention? Or is this something that will need to be scripted?

 

I am hoping for something like referencing all files a file type in Java, for example "/folder/*.jar" as a reference to any and all .jar files in a particular folder.

0 Replies