Hi c'
Assuming your data is being entered in column C of Table 1 on Sheet 1 of your document, starting at cell C2…
Go to the sheet containing the table where you want the data to appear.
Select the cell in row 2 of the column where you wan the data from C2 of the first table to show, then type = to open the Formula Editor.
Click in the editor to place the insertion point there, then:
- type Sheet 1::Table 1::C2
- Click the green checkmark to confirm the formula and close the editor.
Now hover the mouse pointer near the bottom edge of the cell containing the formula.
When a yellow circle (the Fill Handle) appears in the middle of the cell's bottom border, use the pointer to grab it and drag down to fill that formula into as many rows as you need.
The formula (a simple cell reference) will be automatically adjusted to match the row in which each copy is placed.
Note that this is a one way street. Changes made to cells in this column of the second table will replace the formula in that cell with the entered data, and will NOT affect the value in the paired cell in the first Table.
Note also that if each table has a name that is distinct from all other tables in the document, Numbers will have no need for the Sheetname in references to cells on tables other than the one containing the formula.
Regards,
Barry
EDIT: Hi Quinn. Apologies for jumping in. Neglected to refresh my subscription page before coming here and noticed your solution just after sending mine.
B.
