Macro To insert Number to a certain cells in same rows?

[sem]

Good Evening,
Thanks ever so much for all your helps on previous inqueries.
I was woundering if you can assist me with this problem?
I have a list with 3 columns sometimes more and certain cells have less digits than the others;what i need is a VB code
to insert those numbers to other cells in the same rows in ascending order and delete that cell.
If it's not clear i attached a file .
Thanks for your help in advance.
Sem.

[arlu1201]

Sem,

Is this the same request as http://www.excelforum.com/excel-prog...er-series.html

[sem]

Hi Arlu,
Thanks for your assistance but this is different than that tread.
Have Nice evening.
Sem

[sem]

Bump...............

[sem]

Any suggestion would be appreciated.
Thank you
sem

[sem]

Bump..........

[nilem]

Hi Sem, try it

[sem]

Hi Nilem,
Thanks very very much for invaluable help,much appreciated.
The code work perfect with 3 columns list but i was not able to make it work with those list in the attachment?

I have a list with 3 columns sometimes more

,just to let you know my maximum list consist 18 columns.
if you can assist me to solve those in attachment i'll be very greatful.
Thanks again and very much obliged.
sem

[nilem]

try it (see attachment)

[sem]

Hi Nilem,
Thank you very very .........very much for your help,that is exactly what i want.m
much appreciated,have a good day.
Sem