I am designing a spread sheet to track and compile data for a test. In one tab you input sample IDs and corresponding info into table 1. In another tab, a second table pulls out only the relevant data from table 1 and combines it with data typed directly into table 2.
The cells in table 2 are linked to specific cells in table 1. When I sort the data in table 1 it messes up the output of table 2. Since the info in table 1 cell C4 has now changed, table 2 is no longer referencing the correct data.
Is there a way to link tables in different tabs so that if I sort table 1, table 2 will auto sort to maintain the same order?
