How to convert Excel into Flash?

Discussion in 'Mac Apps and Mac App Store' started by Punkwaffle, Oct 20, 2008.

  1. Punkwaffle macrumors regular

    Punkwaffle

    Joined:
    Apr 12, 2004
    #1
    I didn't know what forum to post this in, but this one seemed to fit.

    So I have a pretty elaborate excel spreadsheet, uses VLOOKUPs, data validations, and some if statements.
    The problem is excel will not let me format it the way I want to. I have some graphics that I would like to insert cell values onto, but excel won't let me do it in the way i would like.
    So i figure flash would be able to handle this. If there is another solution, please let me know.
    Anyway, if the easiest way is flash, how can i use my existing spreadsheet/formulas?

    Thanks.
     
  2. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #2
    What kind of graphics are you using?

    You can use an AutoShape, click on it, then in the formula bar, put the cell reference (including the worksheet).

    =Sheet1!$C$2

    Anytime cell C2 changes value, then the AutoShape will automatically update. You also can do that with other graphic figures.
     

Share This Page