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

¿How operate with cells of diferents seehts?

¿How to operate with cells of diferents sheets in a file?

Mac mini

Posted on Mar 5, 2014 1:13 PM

Reply
Question marked as Best reply

Posted on Mar 5, 2014 1:34 PM

If you want to refer to a cell in a different sheet you can enter the references as:


=<Sheet Name>::<Table Name>::<Cell>



so if you have a document with two sheets each with two tables:


Sheet 1

- Table 1

- Table 2


Sheet 2

- Table 1

- Table 2



then you can put the formula in Sheet 1, Table 1 cell A1 that refers to Sheet 2, Table 2, cell F5 like this:

=Sheet 2::Table 2::F5



alternatively, you can select the cell where you want to put the formula, then type the "=", then select the sheet by click the sheet tab at the top, then click the cell in the table you want to reference


The references MUST be in a same document to use Numbers without any extras. IF you want to use information from another document then you can use Applescript to fetch data as needed (not as convenient as live updating but possible).

2 replies
Question marked as Best reply

Mar 5, 2014 1:34 PM in response to Mracu24

If you want to refer to a cell in a different sheet you can enter the references as:


=<Sheet Name>::<Table Name>::<Cell>



so if you have a document with two sheets each with two tables:


Sheet 1

- Table 1

- Table 2


Sheet 2

- Table 1

- Table 2



then you can put the formula in Sheet 1, Table 1 cell A1 that refers to Sheet 2, Table 2, cell F5 like this:

=Sheet 2::Table 2::F5



alternatively, you can select the cell where you want to put the formula, then type the "=", then select the sheet by click the sheet tab at the top, then click the cell in the table you want to reference


The references MUST be in a same document to use Numbers without any extras. IF you want to use information from another document then you can use Applescript to fetch data as needed (not as convenient as live updating but possible).

¿How operate with cells of diferents seehts?

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