[Solved] Loop for printing a statement multiple time in excel


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:

enter image description here

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