I need to post the value of a cell from a sheet to another sheet in numbers.
Here is the situation:
sheet 2, cel B28, needs to be displayed on sheet 1 in cel B15
I am using the Beta version of numbers on my icloud account.
any help would be great
thanks
FS
icloud/numbers beta-OTHER
You specify a cell in a different sheet via sheet name, table name and cell reference.
For example, =Home::Table 1::C31 refers to cell C31 in Table 1 of sheet named Home.
You specify a cell in a different sheet via sheet name, table name and cell reference.
For example, =Home::Table 1::C31 refers to cell C31 in Table 1 of sheet named Home.
sorry I clicked on the wrong button..... This solved my problem... Thanks so much.
Would you be abole to tell me how to add several cell together from diffrent sheet????
Exemple
Cell B5 from sheet HOME
Cell B5 from sheet OFFICE
Cell B5 from sheet WAREHOUSE
Cell B5 from sheet COTTAGE
Thanks
FS
Place the following into the cell you want the sum:
= HOME::Table 1::B5+OFFICE::Table 1::B5+WAREHOUSE::Table 1::B5+COTTAGE::Table 1::B5
how to i use a value of a cell on another sheet
