Long winded description but hopefully helps describe how important excel is but there is still room to grow.
Long winded description but hopefully helps describe how important excel is but there is still room to grow.
This effectively is a data pipeline built within Excel that can either be edited visually or in 'M-Code'.
Why are multiple columns/pages with the various stages of the data insufficient?
What seems to be described is a UI design problem. Once the UI is designed, it also needs programmed in some form, but that doesn't seem to be the problem, just a not-particularly-interesting task required in the implementation.
Not all problems that require programming are programming problems. (In fact, most are not.)
There are always complaints that Excel is a terrible solution to some very specific set of repeated tasks. Every few months, there's a posting about how all we need is a "Better Excel" that would perfectly solve everyone's totally unique 12-step problem.
Such a tool is never going to exist. Thankfully we can build tools specifically for those problems when generic tools aren't good enough. Not every problem is worth a programming solution; there's only so much time and money and paying a bunch of people to cut and paste might just be the better option.