Excel - Database manipulation for presentation and analysing

[bloodline76]

Hi there

I use excel to present and analyse large amounts of data and would like to understand and learn more about the visual basic side so that I can customise and automate reports quickly for myself and others.

Could anyone recommend any books that would be a good start?

Basically I start off with raw data and need to orgainse into charts, graphs and all things pretty

Thanks

 

[Rollo]

When starting out I used the record button extensively to learn the method then google and F1 to refine. Never actually found a useful VBA book!

 

[bloodline76]

Anyone else?

 

[izzop]

What database are you using, and how do you currently pull out the required data?