We are attempting to make a column from 1 sheet auto fill onto a second sheet and add new rows
We are making a database. We made a sheet for this (AllJobs3) and are attempting to have this sheet pull the Primary Column from a master sheet (All41). We only want the primary column as the database doesn't require all fields. We have been messing with INDEX(COLLECT), INDEX(MATCH), & VLOOKUP but we cannot seem to get it to work.
We need the database to pull the primary column (Job Number) and then we are using formulas to pull the rest of the relevant columns from the master sheet. The issue that we have is we need it to create new rows as we add new lines. Is there a formula to pull (Job Number) from the master sheet each time there is a new one added. Any help would be appreciated.
Essentially we need (AllJobs3) Primary column to equal (All41) Primary Column and it to generate new rows as we add them.
Help Article Resources
Check out the Formula Handbook template!