iPad2 Numbers functions

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

  1. Numbersnewbe

    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

    Tim SPRACKLEN iPad Legend

    Joined:
    Jan 3, 2011
    Messages:
    15,236
    Thanks Received:
    121
    Trophy Points:
    0
    Location:
    Scotland
    Ratings:
    +121 / 1
    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

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,268
    Thanks Received:
    2,468
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,019 / 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

    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

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,268
    Thanks Received:
    2,468
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,019 / 1
    You're welcome.
     

Share This Page

Search tags for this page
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
,
ipad numbers can i link sheets
,
ipad numbers copy spreadsheet
,

ipad numbers functions

,
link cells in numbers for ipad
,
numbers app for ipad2
,
numbers functions ipad
,
reference different worksheet 2013 apple number