Hi, my question is pretty simple.
i just need to know how to i create a list of numbers in Column B range from B10 to B200.
i will key in a number in A1, lets say 50
once i key 50 in "A1"
excel will loop and input numbers to B1 to B200
from 1 to 50 and it will stop once it reach 50.
eg.
B1 will show 1
b2 will show 2
b3 will show 3
up to 50 and will stop there
can it be done, please advise. im quite new in the loop function
i just need to know how to i create a list of numbers in Column B range from B10 to B200.
i will key in a number in A1, lets say 50
once i key 50 in "A1"
excel will loop and input numbers to B1 to B200
from 1 to 50 and it will stop once it reach 50.
eg.
B1 will show 1
b2 will show 2
b3 will show 3
up to 50 and will stop there
can it be done, please advise. im quite new in the loop function