How can i use a number from a cell in a different sheet into a new sheet
I am using 2 different sheets.
I want to use into the second one the resulting number from a cell from the first sheet.
OS X Mavericks (10.9.2)
I am using 2 different sheets.
I want to use into the second one the resulting number from a cell from the first sheet.
OS X Mavericks (10.9.2)
This should help (look at the bottom of the reference table):
Thanks.
But I do not understand (neither in Spanish or French that are my native languages ) how to do it.
;-((
Hi jpmarty,
If you mean "documents" when you say" sheet" then I can save you some time. No, you cannot reference a cell in a different file or document. There are some people that will write applescripts to do that but they will not work in iOS.
If both sheets are in the same document:
Tap "=" in the cell you want the value in, tap the upward arrow that appears to the right, then navigate to the first sheet and click in the cell you want the value from. tap the check.
quinn
How can i use a number from a cell in a different sheet into a new sheet