I'm attempting to create a master table of projects linked to smaller tables with subsets of the data that update automatically. For example, if Table 1 contains a master list of projects with associated data, Table 2 could show all of the projects in Antarctica.
Is it possible to link these tables in such a way that when I update the master list with a new project in Antarctica, Table 2 automatically expands to include that project and its data?
Currently I'm accomplishing this by filtering Table 1, manually copying the data I want, and then pasting in a new sheet to create a separate table. I would love to automate this ...
