Need Help! for macro looping, autoinsert comma delimited number

[werko]

Hello!
Need help! to make a loop or something, the function of the macro it's to insert the number of secuence in sheet2 in a comma delimited from sheet1, but at this point it has to be in the manual way and what i want to do is to have it on automatic and stop until find a blank cell.



Will preciate your help!!

[millz]

Hello werko, try the attached.

[Leith Ross]

Hello werko,

I have updated your macro to add the comma between sequence numbers. Here is the macro code...

Please Login or Register  to view this content.

[werko]

Thanks, Millz
it's working almost perfect, can be there a little modification to start the secuence from 1 till finds the blank cell
Correct secuence:,1,2,3,4 and your code gives me a weird secuence:,10,2,1,6...

[millz]

and your code gives me a weird secuence:,10,2,1,6...

I don't understand this, I get the same results with what you have at the right side. The "sequence" is based on the order number.

[werko]

I'm sorrry Millz.
This happens if i change the secuence of the orders in column B on sheet1, Column A, # always start from 1 to x number..

[millz]

Can you show another sample workbook?

So you want the sequence of the order number sorted? Or do you want to leave the order number alone, but only display the "secuence" in the correct sequence?

[werko]

Here's another sample, column C "Secuence" must be in order from 1 to x...

[millz]

Hi werko, see if this is what you want.

[werko]

Thank You!! very much Millz

Preciate you help...