Filling cells with 1,2,3... based on form Value

[dougman824]

Hello,

I am looking to fill in cells to go 1 2 3 ect based on a number on a different sheet. All I really want to do is say for example cell a1=1 a2=2 ect til the cell ax=x. Any suggestions?

to take it a step farther I would like to be able to find then end of the last set I enter numbers like that and then begin a new set based on a new number. I have a pretty good idea how to do this but if someone has an easy solution it would be appreciated.

What I have right now is:

Please Login or Register  to view this content.

I am using k instead of I because I have more loops and actions that will happen inside but I took them out for simplicity.

Thanks

[dougman824]

I was able to solve the first part of my question as I was foolish and was messing up how to activate the next cell over. As it turns out all I needed was to change my second last line of code. See new below:

Please Login or Register  to view this content.

[xladept]

Not sure what you want but this will accomplish what you've posted:

Please Login or Register  to view this content.

[dougman824]

Perfect thanks

[xladept]

You're welcome and thanks for the rep!