riketik

Q: how do I link data from one numbers sheet with another sheet

I have 3 different sheets covering my sales and finances. how can I link certain data in one sheet with the other 2 sheets?

Mac mini, OS X Mountain Lion (10.8.3)

Posted on Sep 16, 2016 6:35 AM

Close

Q: how do I link data from one numbers sheet with another sheet

  • All replies
  • Helpful answers

  • by t quinn,

    t quinn t quinn Sep 16, 2016 7:50 AM in response to riketik
    Level 5 (5,053 points)
    Mac OS X
    Sep 16, 2016 7:50 AM in response to riketik

    Hi riketik,

     

    If you are looking simply to bring a value from one cell to another you can do this by pointing and clicking.

    On the table and sheet you want the value in click in the cell and type "=".

    Navigate to the table and sheet you want the value from and click in the appropriate cell.

    Hit return and you are done.

     

    quinn

  • by riketik,

    riketik riketik Sep 19, 2016 3:15 AM in response to t quinn
    Level 1 (4 points)
    iWork
    Sep 19, 2016 3:15 AM in response to t quinn

    Hi Quinn,

    Thanks for the feedback. This only seem to work when I have multiple tables in one sheet, but doesn't work between different sheets.

  • by t quinn,

    t quinn t quinn Sep 19, 2016 5:52 AM in response to riketik
    Level 5 (5,053 points)
    Mac OS X
    Sep 19, 2016 5:52 AM in response to riketik

    Hi riketik,

     

    I have no problem navigating to another sheet to select a cell in this way. What happens when you click a sheet tab after you type "="? I go to that sheet and am able to click in a table there.

     

    If I am building a table that has many references with another I may start with them both on the same sheet and cut and paste the new table to its proper sheet when I am dome.

     

    quinn