VBA

Hi Andrew

Thanks for your question

This is a massive subject in its own right. Whole books have been written on the subject.

I would suggest the following as a general approach

1. Id the outputs that you require. What data do you need to show
2. Id the inputs, what data will youi start with.
3. List the steps and analysis required to turn your inputs into outputs
4 Break the steps in three above, into a set of discreet operastions and then write the code
5. Finish by building interfaces for your users and formatting tghe data output

Regards

Stephen