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

collegare celle di diverse tabelle

Buongiorno come posso collegare il valore espresso in una cella in una tabella diversa?

Mac OS X (10.7.5)

Posted on Dec 5, 2012 2:11 AM

Reply
Question marked as Best reply

Posted on Dec 5, 2012 10:39 AM

Hello Marionoce,


You reference a cell in an external table by the following syntax:


SheetName :: TableName :: Cell


If the external table is on the same Sheet, SheetName may be omitted.


If the external TableName is Unique in the Document, SheetName may be omitted.


To reference Cell "B2" in Table "Data", in a Document where there is no other table named "Data", you would write:


=Data :: B2


Or, if you were using the reference inside another function, it might look like this:


=ROUND(Data::B2, 2)


Regards,


Jerry

4 replies
Question marked as Best reply

Dec 5, 2012 10:39 AM in response to Marionoce

Hello Marionoce,


You reference a cell in an external table by the following syntax:


SheetName :: TableName :: Cell


If the external table is on the same Sheet, SheetName may be omitted.


If the external TableName is Unique in the Document, SheetName may be omitted.


To reference Cell "B2" in Table "Data", in a Document where there is no other table named "Data", you would write:


=Data :: B2


Or, if you were using the reference inside another function, it might look like this:


=ROUND(Data::B2, 2)


Regards,


Jerry

Dec 11, 2012 6:27 AM in response to Jerrold Green1

Hello Jerrold,

thank you for reply , but your post don't solve my problem,

i would like to explain better the problem:

i have a document that have the function to estimate my product, in the first table ( in the second page) i have my software products and at the and of this table there is the Total ammount, in the next page i have another table whith the hardware products whith the same property. at the and of my doc i have another table, in this table i wont the value that i have in the first and in the second, so in this table i see the total ammount sw/hw.

best regards

Mario

Dec 11, 2012 6:38 AM in response to Marionoce

Mario,


I apologize for my incorrect reply. I should have said that Pages does not have the ability to do external table references. If you must do external table references you can do that in Numbers. I failed to notice that your question came to me in the Pages discussion area instead of Numbers.


A workaround in Pages is to construct your document so that you have only one large, Inline, table. You can format this one table to appear as multiple smaller tables if you carefully remove some of the cell border lines and insert the text in these borderless cells that you would have preferred to put between the separate tables.


Jerry

collegare celle di diverse tabelle

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