Hi Ed, I have altered the script and the sheet to make it work.
The script now takes the range of values from column D, filter out null values, then determine the next empty row to copy the formula into using autoFillToNeighbour.
I have also removed the “bank” rows and add the initial 100 to the formula. Changes were made to the conditions as well to suit with the new structure.
Here’s a video.
