suggestions from gurus

[luvbite38]

Hi,

I am in a complete mess at this mo,

I have alive table, which grows with the time. I am trying to create a dashboard from the table, containing thematic maps, series of dynamic charts and live tables.

I am hoping to run over 30 queries and will create 30 odd reports from that data. I am struggling to decide which is the best way to achieve my target.

All I want to make sure that the workbook doesn't become an elephant and work slower than my brian... :P

Any suggestions, any useful links or info or even a chuckle will be really helpful.....

I kow, you have already guessed it, but I have to VBA to ensure the automation


Best Regards

 

[luvbite38]

sorry, I just noticed that I ate alot of words :$.... trust me i was not playing fill in the blanks or something :D

 

[pbornemeier]

Here are some good general tips. I'm sure there are more:
http://www.excelitems.com/2010/12/optimize-vba-code-for-faster-macros.html

 

[luvbite38]

Thanks P