VBA is a very inefficient solution - it takes a long time to implement a complex solution (often an extra employee to code and maintain), it's unstable, inelegant (needs lots of workarounds), prone to programmer error, hard to hand over code during staff turnover.
And pivot tables are hard to adjust for people not familiar with excel and the format isn't flexible enough to make a presentation 'clean' enough for management consumption. And there are technical bugs with calculated fields and calculated items that I won't bore you with.
So please humour me :-) how do I go about this?
I think the consensus is that the best coders are young (according to gates/jobs/zucerburg) so surely that suggest that it just takes 1-2 years worth of programming knowledge and then a whole load of motivation? I just need pointing in the right direction...
Thanks,
MrS
p.s. thanks Daz I'll give COBAL a look