¿How operate with cells of diferents seehts?
¿How to operate with cells of diferents sheets in a file?
Mac mini
¿How to operate with cells of diferents sheets in a file?
Mac mini
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).
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).
Thank You very much, it solve mu question
¿How operate with cells of diferents seehts?