This book:
https://www.amazon.com/Numerical-Methods-Chemical-Engineers-MATLAB/dp/1466575344/ref=nodl_ Alongside a few of the O Reilly books on VBA should set you up to learn enough VBA to do anything you would need to do. I like the VBA cookbook one as a reference since I can quickly find what I’m working with and write some code.