Hi
I am trying to run a dataset through a group of multi-row formula that I have built but I am having difficulties trying to run one row at a time through the formula.
Basically the idea is to run one through all the formula and then use the output from first run as input for the second row and so on.
I tried using various types of macros to do this but was not able to get any good results maybe because of my lack of experience in using them.
I have attached the example of what I have so far. I need the input file to through all the formula that I have built such that each row would process once and then the output from first calculation would be used to run through the formula again.
Thanks for the help in advance!
Solved! Go to Solution.
You need an iterative macro to do this - setting the iteration to be the field you require for the next row.
You need an iterative macro to do this - setting the iteration to be the field you require for the next row.
Thank you, this helped in resolving the issue