I want to automate a function that has already been created in one of my Excel workbooks as such:
This function is basically a series of cell formulas that do a bunch of math on that sheet and then give out a few outputs based on inputs. So this is basically like asking to write a formula for a single cell and then dragging the formula over a bunch of cells to apply it but with extra steps.
Instead of writing a formula in directly, you’re calling a function which contains the cells of a bunch of formulas that make up the function. The way I most easily can compare this to would be like a function file in Matlab where you give the function inputs when calling the function and then getting outputs.
But in this case the sheet outputs a bunch of cells that I just want to get reference values for. Sorry if this isn’t clear. If need be I can try to provide an example function.
The only method I can find online that would work would be creating a new function formula using developer modules which seems like a pain and so I’m hoping there’s a simpler way.
