Mirror Two Tables in Apple Numbers
Hello! Looking for a pro-tip here:
I need to create a table that dynamically pulls exact data from another table. Luckily, no additional columns will be added but there is a chance additional rows will be.
Description:
- There is a large table of data people are adding to and keeping up to date. Call this table 1.
- I need another table on another tab that can pull that data (for reporting purposes). Call this table 2.
- Table 2 needs to be pulling all the data from table 1 dynamically and be able to flex around the addition of either new rows being added or rows being moved/sorted/etc..
Challenge:
- When I do a typical cell pull, the data is getting out of order (ex: =TABLE1:A2)
Question:
- What is a more stable/accurate way to mirror another table on another tab?
Many thanks!