10 Replies Latest reply: Sep 15, 2010 6:29 PM by Barry
MrTrue Level 1 Level 1 (0 points)
I have a result budget in one spreadsheet, and doing a cash flow budget in another spreadsheet.

How do i reference cells in my result budget from my cash flow spreadsheet? I.e. cell references across two different files.

I am convertering Excel worksheets, and there i have a lot of these kinds of references.

Thanks,
Björn, Gothenburg, Sweden

Mac OS X (10.6.3)
  • Badunit Level 6 Level 6 (11,400 points)
    Not a supported feature. If this is important to you, I would suggest not converting to Numbers until they have this ability.
  • Shihtzustaff Level 1 Level 1 (10 points)
    Ok. That is good to know. I am thinking I may stick with excel at work for those kinds of things. Can you link cells between sheets in the same file?
  • Badunit Level 6 Level 6 (11,400 points)
    Yes, you can reference cells from tables in the same or different sheets in the same file.
  • moe-jiller Level 1 Level 1 (0 points)
    Badunit, Do you have a working example of the syntax for a cell reference to a different sheet? I am trying to pull a $number from one sheet/table into another sheet/table, in the same file but can not get the syntax correct. I did study Chapter 6 in the users manual but do not get the syntax. Thanks ajm
  • Level 8 Level 8 (41,790 points)
    Seems that new glasses are required



    Yvan KOENIG (VALLAURIS, France) samedi 12 juin 2010 22:03:26
  • Barry Level 7 Level 7 (29,470 points)
    To reference B2 on Table 2 on Sheet 3 from a formula in Table 1 on Sheet 1:

    Click on the cell where the formula is to go.
    Enter =
    In the list of sheets and tables on the left, click on Table 2 of Sheet 3 to bring it to the front.
    Click on cell B2
    Type the next character into the formula box to continue the formula. Press return when done.
    On confirming the formula, you'll be returned to the cell below where the formula was entered.

    For the example above, the entry above will show as:

    =Sheet 3::Table 3 :: B2

    or, if "Table 3" is a unique name in the document, as:

    =Table 3 :: B2

    Regards,
    Barry
  • karrigully Level 1 Level 1 (0 points)
    Hi

    Thanks for info, but from my understanding that is only for cells within the same file. I am also trying to reference a cell in another spreadsheet file....not in the same spreadsheet but a total different file. It is possible in Excel as I have been using this function in Excel for many years and want to start using Numbers more but this function does not seem to be possible in Number.

    Does anyone have any ideas or is it just not possible??

    Many thanks in advance for your ideas.
  • Level 8 Level 8 (41,790 points)
    May you open your eyes ?

    The response is given in the second message of this thread !

    *_FEATURE UNAVAILABLE_*

    Yvan KOENIG (VALLAURIS, France) lundi 21 juin 2010 13:24:56
  • ykickamoocow Level 1 Level 1 (0 points)
    Open YOUR eyes.

    I believe they already stated what they were looking for. So didn't need your highlighted document.

    I must say that this is another poor bit of work by Apple. Numbers is not as useful in some basic areas as Excel.

    That is very frustrating, as I also need this ability to link between different files.
  • Barry Level 7 Level 7 (29,470 points)
    ykickamoocow wrote:
    Open YOUR eyes.

    I believe they already stated what they were looking for. So didn't need your highlighted document.


    Yvan's eyes were quite open. He is aware of what the OP asked. He is also aware (as ykickamoocow apparently is not) of what moe-jiller asked. The 'highlighted document' was posted in response to moe-jiller, and directly answered moe-jiller's question.


    I must say that this is another poor bit of work by Apple. Numbers is not as useful in some basic areas as Excel.

    That is very frustrating, as I also need this ability to link between different files.


    If you feel that Numbers is not a suitable tool for what you wish/need to do, then use a tool that is suitable to that job. If you think a feature is needed to make numbers a suitable tool for what you wish/need to do, then use the Provide Numbers Feedback menu item in Numbers Help menu to make a feature request.

    Regards,
    Barry