Weird Excel (Numbers, actually) Question

Discussion in 'Mac Basics and Help' started by pianodude123, Aug 11, 2010.

  1. pianodude123 macrumors 6502a

    pianodude123

    Joined:
    Mar 1, 2005
    Location:
    in the internet
    #1
    I am setting up a new budget spreadsheet, and I have some cells that I want the following to happen:

    Once I enter in a trigger value in cell A1, a bunch of other cells in the same row have calculations done, and values assigned to their cells. The problem is, however is that if I were to change the modifier value, the values that I had already entered would also change. So what I am trying to do is make it so that once I enter in the number I want in A1, the formula calculates and in the other cells, inserts the proper value, and then deletes the formula so that just the values from the original calculation remain. Thus, the cells automatically "unlink" themselves from the formula. Is this possible?
     
  2. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    No.
     
  3. -aggie- macrumors P6

    -aggie-

    Joined:
    Jun 19, 2009
    Location:
    Where bunnies are welcome.
    #3
    The only way you could do it would be to add a macro to the spreadsheet that would remove the links.
     
  4. demingy macrumors newbie

    Joined:
    Jul 20, 2010
    #4
    The closest thing I can think of would be a copy -> paste special where you select "value" in the paste special options.
     

Share This Page