1 Reply Latest reply: Mar 19, 2013 5:37 AM by Wayne Contello
Richieref Level 1 Level 1 (0 points)

I have trouble to connect different tables in different worksheets. If I want to change an item in one table I would like that the same item in a connected table in a different worksheet also changes. I have tried to copy selected cells and paged them to the other worksheet, but that doesnot function.


MacBook (13-inch Late 2009), Mac OS X (10.6.8)
  • 1. Re: how can I connect two tables in different worksheets?
    Wayne Contello Level 6 Level 6 (13,615 points)

    Richieref,

     

    Since I am not sure, in Numbers terminology, what a worksheet is the question is unclear.  In Numbers here are the relevent terms:

     

    A FILE is stored on your hard drive which contains a DOCUMENT which contains SHEETs which contain TABLEs, GRAPHICs, TEXT.   TABLEs contain CELLs which contain text, dates, numbers, formulas.

     

    If you are asking whether a cell in a particular table can refer to another cell in a different document then this is not possible in Numbers.  A cell can refer to a cell in another table of the same (or differerent) sheet so long as the sheets are in the same document.

     

    I hope this help clarify.  You can download the free Numbers Users' Guide which can be very handy too.

    http://support.apple.com/manuals/#productivitysoftware

     

    Page 126 is where the details regarding cell references starts.