Copying a value from one sheet to another

Do you know how to use references in Numbers?

Any cell in any table on any sheet can reference any other cell on any other table on any other sheet. You just need to tell Numbers where to look.

By default, numbers will use the shortest reference possible, so if you set a cell, say B1 to:

=A1

Then numbers will reference the cell A1 in the same table.

If you want to reference a cell on a different table on the same sheet, specify it's name in the format:

=Table 1::A1

This will get the value of cell A1 in the table called 'Table 1'.

If you want a table on a different sheet, just prepend the sheet name:

=Sheet 2::Table 1::A1

Will reference the cell A1 in Table 1 on Sheet 2

(obviously, adjust the sheet and table names as appropriate for your setup).

The only gotcha is that the sheets have to be in the same workbook. There is no support in Numbers for linking across different documents.

Hi mrand,

Click on the cell where you want the result to appear.

Type =

Navigate to any cell, on any table, on any sheet and click on that cell. Press return or click on the green tick to confirm.

Easy!

Regards,

Ian.