I have extracted the maximum integer value from my data set into cell V20.

On Sheet 3, I would like to have the A column populated by all the integers from 1 to this maximum value (which in this case is 19).

Whilst this would be easy enough just to drag out, I have to do it for many different workbooks, so a simple VBA loop would be really helpful!

Along the lines of:

For i=1 to V20

Cells(i,1).Value = i

End

Thanks