Forum Discussion
Autofill select rows from one sheet to another
Hi,
You can type below formula in Cell A1 in each secondary sheet:
=VSTACK(Table3[[#Headers],[Full Address]:[MAILER]], FILTER(Table3[[Full Address]:[MAILER]],Table3[MAILER]=TEXTAFTER(CELL("filename",A1),"]"),""))Breakdown of the formula:
TEXTAFTER(CELL("filename",A1),"]") -> gets the secondary sheet name, such as "1-Dannenberg".
FILTER(Table3[[Full Address]:[MAILER]],Table3[MAILER]=TEXTAFTER(CELL("filename",A1),"]"),"") -> filter out column I and column J with column J = sheetName.
VSTACK -> stack table headers and data vertically.
In case you want to check the formula step by step by yourself, here is how to open the "formula builder":
Put your cursor at cell A1, select the function you want to check (e.g VSTACK, or FILTER), then click the "fx" icon (highlighted in red rectangle).
Then the formula builder will open in the right:
Is there something that delineated the mailer "ALLEN" to collect these lines to the secondary sheet?
Yes, it is the FILTER function. and I use =TEXTAFTER(CELL("filename",A1),"]") to get the secondary sheet name.
- So, if I leave this in place on the secondary sheet, if I add another entry for the mailer ALLEN on the master list, will it also auto populate to the secondary list, and will updates also transfer through?
Yes.
FILTER operates on "Table1".
So as long as your new entry is still in "Table1", secondary sheet can be auto populated from master sheet.
Here is how you can add new rows in a Table: