Your description is not that detailed, but I took a shot, and from what I understand you might be looking to have something like this:
Where you would put a number into B1, and then column C would print out as many statements as requested.
Here’s the formula to that:
C1=IF(ROW()<=B$1,"Enter load for Span " & ROW(),"")
If this is not what you were looking for, show some effort and explain your situation more accurate 😉
2
solved Loop for printing a statement multiple time in excel