Hello wizards, I have two different Numbers sheets (tables with data). I want to "sync" data from one cell in sheet A to a cell in sheet B, so that when I change the content in the cell in sheet A the data in the cell in sheet B changes. How to do this? Thanks for your help, Paul
If the two tables are on the same sheet and you want cell A2 of Table 1 to appear in cell A2 of Table 2, the formula in cell A2 of Table 2 would be =Table 1::A2
If the two tables are in different sheets, say Sheet A and Sheet B, the formula would be =Sheet A::Table 1::A2
Thanks Badunit!
Fantastic Barry! Thanks!
Adding to this statement in Badunit's solution:
"If the two tables are in different sheets, say Sheet A and Sheet B, the formula would be =Sheet A::Table 1::A2"
If each of the tables has a name that is distinct within the document, there is no need to include the Sheet name in the cell address in the formula.
Example: The Tale on Sheet A is named "Main" and the document contains no other Table with that name.
The table containing the formula is named 'Branch"
"Branch" may be on th same Sheet as "Main", or may be on another Sheet in the same document.
Formula in a cell on Branch: = Main::A2
Regards,
Barry
How about if the two tables A and B are in different Numbers documents?
Out of luck in that case. Numbers documents can't reference cells in external documents, including other Numbers documents.
Regards,
Barry
Numbers
