how to filter serial numbers with macro

[bhandari]

https://drive.google.com/open?id=1-kA3-Z4sFfSET2uHxkHnjFu9wiJRvVB_

Please find the attachment above

there are 3 columns, serial number,co-ordinates(x,y)
coming to serial numbers it is not in proper arranged serial number EX1,2,3,11,14,15,18,....214..)

i want to arrange serial number properly instead of doing individulally, can any one fix this issue with serial number
EX1,2,3,4,5,6....214..) with coordinates.

i have tried sorting ascending but its not working

i hope it will work with macro

 

[oldbrewer]

[TABLE="width: 512"]
<colgroup><col span="8"></colgroup><tbody>[TR]
[TD]MYTAG[/TD]
[TD]Position X[/TD]
[TD="colspan: 2"]Position Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+01.00[/TD]
[TD="align: right"]290303.8[/TD]
[TD="align: right"]1459900[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="colspan: 2"]=MID(A2,3,25)*1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+02.00[/TD]
[TD="align: right"]290269.4[/TD]
[TD="align: right"]1459994[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+03.00[/TD]
[TD="align: right"]290247.1[/TD]
[TD="align: right"]1460091[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+04.00[/TD]
[TD="align: right"]290234.3[/TD]
[TD="align: right"]1460190[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+05.00[/TD]
[TD="align: right"]290216[/TD]
[TD="align: right"]1460289[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+06.00[/TD]
[TD="align: right"]290187.3[/TD]
[TD="align: right"]1460384[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+07.00[/TD]
[TD="align: right"]290157.2[/TD]
[TD="align: right"]1460480[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+08.00[/TD]
[TD="align: right"]290131.3[/TD]
[TD="align: right"]1460576[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+09.00[/TD]
[TD="align: right"]290110.2[/TD]
[TD="align: right"]1460674[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+10.00[/TD]
[TD="align: right"]290091.4[/TD]
[TD="align: right"]1460772[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+100.00[/TD]
[TD="align: right"]288465.5[/TD]
[TD="align: right"]1469310[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+101.00[/TD]
[TD="align: right"]288453[/TD]
[TD="align: right"]1469409[/TD]
[TD="align: right"]101[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+102.00[/TD]
[TD="align: right"]288445.2[/TD]
[TD="align: right"]1469509[/TD]
[TD="align: right"]102[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+103.00[/TD]
[TD="align: right"]288442.1[/TD]
[TD="align: right"]1469609[/TD]
[TD="align: right"]103[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+104.00[/TD]
[TD="align: right"]288443.8[/TD]
[TD="align: right"]1469709[/TD]
[TD="align: right"]104[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+105.00[/TD]
[TD="align: right"]288450.3[/TD]
[TD="align: right"]1469808[/TD]
[TD="align: right"]105[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+106.00[/TD]
[TD="align: right"]288461.5[/TD]
[TD="align: right"]1469908[/TD]
[TD="align: right"]106[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+107.00[/TD]
[TD="align: right"]288477.4[/TD]
[TD="align: right"]1470006[/TD]
[TD="align: right"]107[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+108.00[/TD]
[TD="align: right"]288498[/TD]
[TD="align: right"]1470104[/TD]
[TD="align: right"]108[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+109.00[/TD]
[TD="align: right"]288523.2[/TD]
[TD="align: right"]1470201[/TD]
[TD="align: right"]109[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+11.00[/TD]
[TD="align: right"]290074.8[/TD]
[TD="align: right"]1460871[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+110.00[/TD]
[TD="align: right"]288553.1[/TD]
[TD="align: right"]1470296[/TD]
[TD="align: right"]110[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+111.00[/TD]
[TD="align: right"]288587.4[/TD]
[TD="align: right"]1470390[/TD]
[TD="align: right"]111[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+112.00[/TD]
[TD="align: right"]288626.1[/TD]
[TD="align: right"]1470482[/TD]
[TD="align: right"]112[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+113.00[/TD]
[TD="align: right"]288669.2[/TD]
[TD="align: right"]1470573[/TD]
[TD="align: right"]113[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+114.00[/TD]
[TD="align: right"]288716.6[/TD]
[TD="align: right"]1470661[/TD]
[TD="align: right"]114[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+115.00[/TD]
[TD="align: right"]288768.1[/TD]
[TD="align: right"]1470747[/TD]
[TD="align: right"]115[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+116.00[/TD]
[TD="align: right"]288823.6[/TD]
[TD="align: right"]1470830[/TD]
[TD="align: right"]116[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+117.00[/TD]
[TD="align: right"]288883[/TD]
[TD="align: right"]1470910[/TD]
[TD="align: right"]117[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+118.00[/TD]
[TD="align: right"]288946.1[/TD]
[TD="align: right"]1470988[/TD]
[TD="align: right"]118[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+119.00[/TD]
[TD="align: right"]289012.9[/TD]
[TD="align: right"]1471062[/TD]
[TD="align: right"]119[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+12.00[/TD]
[TD="align: right"]290063.1[/TD]
[TD="align: right"]1460970[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+120.00[/TD]
[TD="align: right"]289082.5[/TD]
[TD="align: right"]1471134[/TD]
[TD="align: right"]120[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0+121.00[/TD]
[TD="align: right"]289152.3[/TD]
[TD="align: right"]1471205[/TD]
[TD="align: right"]121[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

they are now numbers not text and can be sorted normally[/TD]
[/TR]
</tbody>[/TABLE]