How to convert Excel into Flash?

[Punkwaffle]

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.

 

[exegete77]

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.