sort the table using vba

[gvgbabu]

Hello everybody

i have a table with
1 230 450 1 301
2 230 450 2 340
7 230 450 7 350
65 230 450 301 501
67 230 450 340 502
71 230 450 350 546
129 230 450 501 701
131 230 450 502 702
135 230 450 546 747




i want to sort in order that


select 1st column having number "1"
row containing "1" number 5th column text is "301"
2nd row should be 4th column with "301"
it has 5th column "501"
3rd row should be 4th column with 501 and so on untill there no number matching 5th and 4th column


Then select "2" in the 1st column and do the same


this process goes on end of the 1st column


the above example should have
1 230 450 1 301
65 230 450 301 501
129 230 450 501 701
2 230 450 2 340
67 230 450 340 502
131 230 450 502 702
7 230 450 7 350
71 230 450 350 546
135 230 450 546 747


guide me

thanks in advance
gvg

[gvgbabu]

hi

is it possible to sort like above

Thanks
gvg