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

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)

Posted on Mar 5, 2015 3:50 AM

Reply
4 replies

Mar 5, 2015 9:52 AM in response to jpmarty

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

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