1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

iPad2 Numbers functions

Discussion in 'iWork Forum' started by Numbersnewbe, Jun 28, 2011.

  1. Numbersnewbe
    Offline

    Numbersnewbe iPF Noob

    Joined:
    Jun 28, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    South Africa
    Ratings:
    +0 / 0
    What function must I use to copy (link) a totalled number (cell address) from one worksheet to another cell position in a different worksheet? In other words as I enter data in one worksheet I want its total to be carried across to another worksheet for consolidation purposes.
  2. Tim SPRACKLEN
    Offline

    Tim SPRACKLEN iPad Legend

    Joined:
    Jan 3, 2011
    Messages:
    15,246
    Thanks Received:
    120
    Trophy Points:
    0
    Location:
    Scotland
    Ratings:
    +120 / 0
    I don't know the answer to your specific problem (I'm sure other Members will be along soon) but I wonder if you've seen the iPad's iWork's Help pages....


    Apple - Support - iOS Apps - Welcome

    Tim
  3. twerppoet
    Online

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,935
    Thanks Received:
    1,806
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,912 / 1
    Go to the worksheet that you want the information echoed in.

    Double tap the cell where you want it to apper. This enters editor mode. Select the = sign to enter formula mode.

    Navigate to the worksheet where the formula/data already exists and tap on the cell containing the formula.

    You'll see the complete path to the cell entered in the editor. Tap on the checkmark to the right to enter the data.

    When you go back to the receiving worksheet you should see your value.
  4. Numbersnewbe
    Offline

    Numbersnewbe iPF Noob

    Joined:
    Jun 28, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    South Africa
    Ratings:
    +0 / 0
    Thank you for the advice - really easy when you know how! My financial worksheets are now all in sync thanks to you!
  5. twerppoet
    Online

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,935
    Thanks Received:
    1,806
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,912 / 1
    You're welcome.

Share This Page

Search tags for this page
blank worksheet with cell references on ipad numbers
,
can i reference a cell in a different spreadsheet in numbers for ios
,
how to do arithmetic functions on ipad numbers
,
icloud numbers reference cell in different tab
,
ios numbers referencing other sheets
,

ipad numbers can i link sheets

,

ipad numbers copy spreadsheet

,

ipad numbers functions

,
ipad numbers link sheets
,
ipad numbers worksheet cell reference
,
link cells in numbers for ipad
,
link numbers ipad
,
linking cells in numbers for ipad
,

numbers app for ipad2

,
numbers app funtions
,
numbers app how do you reference another cell on a different worksheet in numbers
,

numbers functions ipad

,
numbers ipad link tabs
,
reference different worksheet 2013 apple number
,
transferring cell totals to another spreadsheet