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

Problem linking spreadsheets within numbers

I am trying to use data from one spreadsheet in another, but whenever I link a cell from the original it is returning the same detail regardless of which cell I try to link, and it doesnt include the spreadsheet name?


iPad Pro, iPadOS 14

Posted on Aug 1, 2021 8:34 AM

Reply
Question marked as Best answer

"Sheets" in Numbers do not have cells. A Sheet id the large 'canvas' on which you can place Tables and other objects, such as images, text containers or charts (graphs).


Tables hav cells, and each cell on a Table has an address consisting of its column letter and its row number.


The full address of a cell also includes the name of the Table containing the cell and the name of the Sheet on which that table in placed.


You wrote: " I am selecting ‘=‘ in the destination sheet/cell and no matter where I then choose on the source sheet/cell it is populating the formula box with the same text"


Here is a description of steps for doing this.


The example uses a Document with four sheets, named Sheet 1, Sheet 2, Sheet 3, and Sheet 4.

Each sheet contains a single table, named Table 1 on sheets 1 to 3, and named "Source" on Sheet 4.

You want to get the value in cell E5 of the table "Source" and place it in cell B5 of the table on Sheet 1



  • Click on cell B5 in the destination table to select that cell.
  • Press = to open the Formula Editor.

  • Click the tab for Sheet 4 to move focus to that sheet

Note that the Formula Editor follows you to Sheet 4.

  • On the table "Source, click cell E5.

  • Then click the green checkmark on the Formula editor to confirm the formula and close the editor and return the focus to Table 1 on Sheet 1.


Note that the cell reference included the nam of the Table, but not of the Sheet. As the document contains only a single table named "Source", Numbers will drop the sheet name as it is not needed to locate the cell.


If this process does not give the desired result, we'll need to take a closer lo at how 'your source table differs from other source tables in your document.


Regards,

Barry.







Posted on Aug 1, 2021 10:55 AM

6 replies

Aug 1, 2021 9:55 AM in response to gefmp1

Please clarify.


    Are you attempting to reference a cell on another Table within the same Spreadsheet Document,

or are you attempting to reference a cell on a Table in a second Numbers Spreadsheet Document?


The first is a simple task; the second is not possible—a Numbers document has no means of getting information directly from another Numbers document using a formula.


Regards,

Barry

Question marked as Best answer

Aug 1, 2021 10:55 AM in response to gefmp1

"Sheets" in Numbers do not have cells. A Sheet id the large 'canvas' on which you can place Tables and other objects, such as images, text containers or charts (graphs).


Tables hav cells, and each cell on a Table has an address consisting of its column letter and its row number.


The full address of a cell also includes the name of the Table containing the cell and the name of the Sheet on which that table in placed.


You wrote: " I am selecting ‘=‘ in the destination sheet/cell and no matter where I then choose on the source sheet/cell it is populating the formula box with the same text"


Here is a description of steps for doing this.


The example uses a Document with four sheets, named Sheet 1, Sheet 2, Sheet 3, and Sheet 4.

Each sheet contains a single table, named Table 1 on sheets 1 to 3, and named "Source" on Sheet 4.

You want to get the value in cell E5 of the table "Source" and place it in cell B5 of the table on Sheet 1



  • Click on cell B5 in the destination table to select that cell.
  • Press = to open the Formula Editor.

  • Click the tab for Sheet 4 to move focus to that sheet

Note that the Formula Editor follows you to Sheet 4.

  • On the table "Source, click cell E5.

  • Then click the green checkmark on the Formula editor to confirm the formula and close the editor and return the focus to Table 1 on Sheet 1.


Note that the cell reference included the nam of the Table, but not of the Sheet. As the document contains only a single table named "Source", Numbers will drop the sheet name as it is not needed to locate the cell.


If this process does not give the desired result, we'll need to take a closer lo at how 'your source table differs from other source tables in your document.


Regards,

Barry.







Aug 1, 2021 11:47 AM in response to Barry

Thank you - whilst i was doing exactly as you have said, what I hadn’t grasped is the point about tables versus sheets, and so realised all of may source data is within a table and I had a hidden table title which was being populated in my destination cell and making me think I had some kind of error (not sure how I came to have created the table title at some point…). Anyway, Ive worked out how to change this so, onwards! Appreciate the response.

Problem linking spreadsheets within numbers

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