I am trying to make several tables that all include the same column that would be taken from a 'master table' (in my example it is table 1). In the future, there will be many new groups added to table 1 so I would like table 2 to automatically update whenever there is a new group. I tried using '=Table1(Group)' but this included all the repeats of the groups which I do not want. Thanks in advance for your help.
Bookmarks