Welcome to iPadForums.net Guest - Click Here to Register

iPad2 Numbers functions

This is a discussion on iPad2 Numbers functions within the iWork Forum forums, part of the iPad App Store category; 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 ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    iPad Noob!
    Member #
    71145
    Join Date
    Jun 2011
    Location
    South Africa
    Posts
    2

    iPad2 Numbers functions

    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. Ads


  3. #2
    iPF Legend
    Member #
    27654
    Liked
    119 times
    Join Date
    Jan 2011
    Location
    Scotland
    Posts
    15,248
    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

  4. #3
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    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.

  5. #4
    iPad Noob!
    Member #
    71145
    Join Date
    Jun 2011
    Location
    South Africa
    Posts
    2
    Thank you for the advice - really easy when you know how! My financial worksheets are now all in sync thanks to you!

  6. #5
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    You're welcome.


Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Replies: 16
    Last Post: 05-02-2011, 12:41 AM
  2. What are some other cool JB functions for ipad?
    By Kabona in forum iPad Hacking
    Replies: 8
    Last Post: 04-30-2011, 01:27 AM
  3. Replies: 4
    Last Post: 03-22-2011, 04:42 PM
  4. Replies: 5
    Last Post: 01-10-2011, 12:43 PM
  5. Numbers - running MS excel functions
    By Jaquin in forum iPad General Discussions
    Replies: 1
    Last Post: 12-08-2010, 03:12 PM

Search tags for this page

cell reference worksheet
,

how to use numbers on ipad 2

,
ipad numbers app functions
,
ipad numbers can i link sheets
,
ipad numbers copy spreadsheet
,

ipad numbers functions

,
ipad numbers worksheet cell reference
,
numbers app for ipad2
,
numbers functions ipad
,
tab function ipad 2
Click on a term to search for related topics.