Linking/adding rows using 2 spreadsheets
I am having an issue that might be simple to solve, but I can't seem to find an efficient solution.
I have 2 spreadsheets:
- One with the ID, name, Lot and several other columns with product specification information
- Another just with the same ID's, names and Lots, and a few bits more that don't pair with the first one.
On the first spreadsheet, the QA team fills a form that will issue individual rows for each product.
What I want to happen is, everytime the QA's fill up a form (add a row to the first spreadsheet) I want to see that also reflected on the second spreadsheet, copying only the common items (ID, name and LOT).
I've tried to do "Cell linking" but it only worked for the ones that are already there.
Thanks in advance.