Your time would be better spent learning the basics of Excel and working with data. I build complex reports in Excel with out using VBA.
I understand your observation. I don't have your knowledge but I have some knowledge of excel. But I never dedicated myself to VBA, until now. This is an urgent and complicated case and the person asked me to be able to improve performance in a super short amount of time. When I have time, I will have to rebuild it all over again, with data storage and stuff, in a different way. But for now... it is what it is. However, I have already reduced it in a first phase from 300mb to 100mb and then to 50mb, saving in binary.
But I promise I will learn VBA through the forum. I like it.