Welcome to iPadForums.net Guest - Click Here to Register

Numbers, changing cell info on one sheet, changes cell on second sheet

This is a discussion on Numbers, changing cell info on one sheet, changes cell on second sheet within the iPad Help forums, part of the Apple iPad Discussions category; Hi All I have moved a spread sheet across from excel, yes I am a happy convert, but I want o be able to replicate ...

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 #
    47313
    Join Date
    Apr 2011
    Posts
    2

    Numbers, changing cell info on one sheet, changes cell on second sheet

    Hi All
    I have moved a spread sheet across from excel, yes I am a happy convert, but I want o be able to replicate a simple invoicing system i set up on excel. There I was able to enter my invoice data on one sheet. From one line on the sheet, I was able to copy the data across to a second sheet that was set up as an invoice I could print fro my clients. The first sheet stayed as my accounts record, accumulating my records and eventually forming my records for tax purposes.
    I can copy the information across on numbers manually, but I want to be able to enter the data onto one sheet, and it appear on the other automatically. I have tried copying the value, but it has not worked.

    Thanks for any ideas
    Kathryn

  2. Ads


  3. #2
    iPF Legend
    Member #
    27654
    Liked
    119 times
    Join Date
    Jan 2011
    Location
    Scotland
    Posts
    15,248
    I've moved your post to the Help section of the Forum, with a permanent redirect, because I think it will get better notice there.

    Tim

  4. #3
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    Go to the cell you want to replicate the data too.

    Double tap on the cell to pull up the cell editor.

    Choose the = sign to go into formula mode.

    Choose the sheet tab that contains the original cell, then drag the screen around until you can see that cell. (when dragging best to avoid touching actual tables and cells if possible. It reduces the chance that you will accidentally pick the wrong cell)

    Tab on the original cell.

    You will see the cell description appear in the editor field. Format is Tab Name::Table Name::Cell example =(Sheet 1::Table 1::A1)

    Tap on the green check mark to the right.

    That's it. You can only enter data in the original cell. If you try to enter it into the destination cell you will overwrite the formula.

  5. #4
    iPad Noob!
    Member #
    47313
    Join Date
    Apr 2011
    Posts
    2

    More about numbers, emailing one sheet only

    Thanks for the advice. It works easily, but I do not understand why I could not find it the official help.
    Next hurdle in this project is that I want to be able to email one sheet in the spreadsheet, not all sheets and tables. Any suggestions?
    K

  6. #5
    iPF Legend
    Member #
    28530
    Liked
    1523 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,431
    Well, not directly.

    Here are some kludgy workarounds. One versatile but a lot of work. The second a pain, but probably ok looking. The third a real quick and dirty cheat, but probably good enough to send a quick chart to the boss or customer.

    One:

    You can copy the tables and sheet elements you want, create a new document and paste them over, and mail that document.

    To get the entire sheet, tap in a blank spot somewhere and choose Select All from the popup menu. No tap again on of the selected elements and choose copy. If you tap on a table, you need to tap on the little target circle at the upper left corner, otherwise it deselects the table. Very annoying.

    You can also select only some of the elements on a sheet. Tap one element to select it, then tap and hold on that element while using another finger to tap the other elements you want to select. Copy them all the same was as before.

    Now go back to the document list and create a new, blank document. Tap on the default table to select it, again on the upper left target to get the menu and delete the table.

    Now tap anywhere on the blank sheet to get the Paste option. You may have to rearrange the elements a bit after.

    Now you can mail that document with just that sheet.


    Two:

    Export to DropBox as a PDF. Re-import to one of the PDF editors that will let you delete pages, then email the page you want. Sorry, I don't remember what PDF programs let you edit pages, but I know there are at least a couple.

    Three:

    Arrange the view the way you want, then take a snapshot of the screen. You do this by briefly pressing the Home and Power button at the same time.

    Use an App like Adobe Photoshop Express to rotate or crop the picture as needed. Then open it in the Photos app and mail it from there.


Home | Forum | Active Topics | What's New

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. Is There An APP for Sheet Music?
    By MattMI in forum iPad General Discussions
    Replies: 10
    Last Post: 06-25-2011, 07:41 PM
  2. Changing Cell Format in Numbers
    By MikeV99 in forum iPad Help
    Replies: 15
    Last Post: 05-28-2011, 11:35 AM
  3. Creating sheet music
    By DontUnderstandMyIpad in forum iPad General Discussions
    Replies: 5
    Last Post: 04-19-2011, 01:37 PM
  4. Sheet music
    By Lizard king in forum iPad General Discussions
    Replies: 26
    Last Post: 04-01-2011, 01:31 AM
  5. Ipad to read Sheet Music at performances?
    By FPinto in forum New Member Introductions - Site Assistance
    Replies: 4
    Last Post: 08-20-2010, 06:45 AM

Search tags for this page

apple numbers carry values across sheets

,

apple numbers cell info different sheets

,

how to carry forward totals from one sheet to another in numbers for mac

,

how to carry sum from one sheet to another in apple numbers

,

how to email a sheet in numbers

,
how to reference sheet in apple numbers
,

link number from one sheet to another sheet apple numbers

,

numbers reference another sheet

Click on a term to search for related topics.