Weird Excel (Numbers, actually) Question

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

  1. pianodude123 macrumors 6502a


    Mar 1, 2005
    in the internet
    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


    May 16, 2008
  3. -aggie- macrumors P6


    Jun 19, 2009
    Where bunnies are welcome.
    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

    Jul 20, 2010
    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