How do you permanently link the value of a cell formula in one spreadsheet to a cell in another spreadsheet?
I would like to input one day's data on one sheet, and link a few specific cells to another sheet, so I can aggregate data over time.
thank you!
Hi Mom,
When you say "Spreadsheet," do you mean "Spreadsheet Document," which refers to the entire document contained in saved in a .numbers file.
Or are you referring to a "Sheet"—a large 'canvas on which may be placed several types of object, such as images, charts, text boxes, shapes of Tables?
From your second sentence, my interpretation is that you want the result of a formula on one Table to be transferred to a specific cell on a second table on a different Sheet within the same (Spreadsheet) Document.
That can be done with a formula in the receiving cell consisting of a simple cell reference to the cell in the first table containing the value to be transferred.
Example:
You want the result of a formula in cell B7 of a table named "Data" on Sheet 1 of your Document
to be displayed in cell C9 of a table named "Summary" on Sheet 2 of the same document.
In the Table "Summary", click cell C9 to select it, then press = to open the Formula Editor.
With the insertion point ( | ) in the editor, click the tab for Sheet 1, then click cell B7 on the table "Data". then click the green checkmark on the Formula Editor (which will have followed you to Sheet 1) to confirm the formula and close the editor.
Return to Sheet, where cell C9 of Summary will now display the same value as cell B7 of Data.
Change the value in B7 of Data, and the value in C9 of Summary will change to match it.
For an example of this type of use (with a more interesting formula in the receiving table), see the Summary by Category table in the Personal Budget Template included in the Template Chooser of Numbers.
Regards,
Barry
PS: If you did mean "Spreadsheet" and "Spreadsheet" as two different documents, the answer is 'You don't." Numbers documents cannot transfer information directly between different documents.
B.
Hi Mom,
When you say "Spreadsheet," do you mean "Spreadsheet Document," which refers to the entire document contained in saved in a .numbers file.
Or are you referring to a "Sheet"—a large 'canvas on which may be placed several types of object, such as images, charts, text boxes, shapes of Tables?
From your second sentence, my interpretation is that you want the result of a formula on one Table to be transferred to a specific cell on a second table on a different Sheet within the same (Spreadsheet) Document.
That can be done with a formula in the receiving cell consisting of a simple cell reference to the cell in the first table containing the value to be transferred.
Example:
You want the result of a formula in cell B7 of a table named "Data" on Sheet 1 of your Document
to be displayed in cell C9 of a table named "Summary" on Sheet 2 of the same document.
In the Table "Summary", click cell C9 to select it, then press = to open the Formula Editor.
With the insertion point ( | ) in the editor, click the tab for Sheet 1, then click cell B7 on the table "Data". then click the green checkmark on the Formula Editor (which will have followed you to Sheet 1) to confirm the formula and close the editor.
Return to Sheet, where cell C9 of Summary will now display the same value as cell B7 of Data.
Change the value in B7 of Data, and the value in C9 of Summary will change to match it.
For an example of this type of use (with a more interesting formula in the receiving table), see the Summary by Category table in the Personal Budget Template included in the Template Chooser of Numbers.
Regards,
Barry
PS: If you did mean "Spreadsheet" and "Spreadsheet" as two different documents, the answer is 'You don't." Numbers documents cannot transfer information directly between different documents.
B.
link cells in different spreadsheets?
