Firstly, I feel amazed at how small the world is, I had faced exactly the same problem during the development of a student management system in MS Excel Macros, which led me to learn google app scripts and I ended up redoing the entire thing on google app scripts and a lot more since then.
I could really connect to your problem at this point, and would be more than happy to help a friend out in need.