I think it's fallacious to think everybody has the natural disposition and curiosity to want to write software. Writing has been around forever, and most people don't want to do it beyond purely functional communication, and even those who do want to go beyond that are mostly terrible at it. That lady could have automated her job if she really wanted to and was motivated enough to do it; she simply preferred to be a ditch digger than to design a ditch digging machine.
It doesn't help that "designing ditch digging machines" is in such high demand that most companies are really only able to hire mediocre people to fill those roles. Leonardo da Vinci is not working on sox compliance at a fucking bank.
There's a good chance that the payoff for that bank automating "take a set of dates in an Excel file, search each one individually into an internal search tool, then Ctrl+f the result report and verify that every code listed in the original document exists in the report" is not even there, because the first attempt will have insufficient monitoring or verifications to catch silent failures and introduce an expensive issue caught months after the fact that leads to a huge remediation scramble and requires more development than initially expected to address, not to mention the constant need for maintenance in updating the software and making sure it continues to run (which also involves a rotating cast of programmers joining, needing to learn the software, and leaving). Leonardo might do it right the first time, but he's not doing it for cheap and not going to make it his life's work. Joe Schmoe can do it cheaper but it's going to take a while, have an ongoing maintenace burden, and probably some mistakes made along the way. That lady can do it for even cheaper than Joe Schmoe can without many headaches.