Forum Discussion
Expand Table When New Data is Added Elsewhere
Hello everyone!
I have an issue with the setup I have below:
Table 1 is automatically updated with responses from a MS Form on SharePoint, but because the formula in cell G4 spills over into the cells below it, it cannot go in Table 2, or at least as I understand it cannot. The data in Table 2 is populated based on the values in column G. The issue arises when new data is added to Table 1 and Table 2 is big enough to catch the change, i.e. a new ID is added in cell G6. Is there a formula or way to setup Table 2 so that it automatically expands down a row when a new ID is added? I need to do this without VBA code, so if it is not possible, I can just manually extend the table down.
Thanks in advance!
Hi Corder
No way, Table2 must be converted to a range that will dynamically adjust with your Table1
in G3: =Table1[#Headers]
in G4: =FILTER(Table1[ID], Table1[Type]="a")
in H4: =XLOOKUP($G4#, Table1[[ID]:[ID]], Table1[Name]) and copy right
OR (much easier), in G4: =FILTER(Table1, Table1[Type]="a")
3 Replies
Hi Corder
No way, Table2 must be converted to a range that will dynamically adjust with your Table1
in G3: =Table1[#Headers]
in G4: =FILTER(Table1[ID], Table1[Type]="a")
in H4: =XLOOKUP($G4#, Table1[[ID]:[ID]], Table1[Name]) and copy right
OR (much easier), in G4: =FILTER(Table1, Table1[Type]="a")
