Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Punkwaffle

macrumors regular
Original poster
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.
 
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.