You can use the following formula to access data from one sheet/table/column to another:
where Sheet1/Table1/Column1 are names of the source sheet/table/column. You can insert this formula into any cell of the target table (into appropriate column), and should mirror all cells values from the source column.
Thanks for the prompt response. It sounds like the assignment is for the whole column. Is it possible to assign just a specific cell?
1 person found this helpful
Yes, first you need to switch the target table to "Work Cell by Cell" mode (select the target table, and use main menu Table->Work Cell by Cell).
Now you can use formulas like = Sheet1::Table1::A1
(alternativaly you can switch to "Work Cell by Cell" mode and back via popup icon:
that shoudl appear after you typed the formula.