Hi. Appreciate any solution to this looping problem. I can't run the VB macro code due to procedure too long. The looping as below:
n = 5
For j = 5 To 7
Sheets("A").Cells(j, 121) = Sheets("A").Cells(5, n)
n = n + 1
Next j
n = 5
For j = 8 To 10
Sheets("A").Cells(j, 121) = Sheets("A").Cells(6...