You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

link cells in different spreadsheets?

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!


Posted on Mar 14, 2021 5:29 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 15, 2021 12:01 AM

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.


1 reply
Question marked as Top-ranking reply

Mar 15, 2021 12:01 AM in response to Mom in San Anselmo

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?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.