Numbers mirror imput
In Numbers, how would I go about mirroring the number(quantity) input on one page reflected on another page of the same spreadsheet?
MacBook Air (13-inch, Early 2014), iOS 11.4
Question marked as
Hi O'
If you mean 'how can I get the value entered in cell B2 of Table 1 on Sheet 1 of my spreadsheet document to be copied to cell X7 of Table 1 on Sheet 2 of the same spreadsheet document?', you can do that with a formula in X7 that simply references B2.
Because the cells are on different tables, you will need to include the Table name in the reference. Because the two Tables have the same name, you will also need to include the Sheet name of the Sheet containing the Table containing the referenced cell.
You can enter the formula into cell X7:
Click on X7 to select it. Type = to open the Formula editor.
In the Formula Editor, type: Sheet 1::Table 1::B2
Click the green checkmark to confirm the formula and close the editor.
You can also 'build' the formula, using the mouse:
Click on X7 to select it. Type = to open the Formula editor.
Click the tab for Sheet 1.
When the view switches to Sheet 1, Click cell A2 of Table 1.
Click the green checkmark to close the formula editor and return to Sheet 2.
Regards,
Barry