Meh, you should probably be using either python or an RDBMS. Most non trivial applications of excel come from a lack of IS knowledge IMO. It’s easy to do but it makes everyone around you less happy.
I disagree as both a python and rdbms user. Excel is great for millions of one off use cases by users who don’t know how to program and don’t know sql and/or have access to rdbms infrastructure. And I think that’s ok.
If I want to create a reproducible data process then I’ll build it in python and maybe some data share or database.
But tons of work can be done in excel that isn’t worth the cost to build in something else.
I don’t include Macros, if I’m programming in Excel, I should probably do that in something that is better designed.
