Sorting Time according to Accending Order

[rsami]

SORTING.xls


in the attached sheet there can be data relevant to 1-40 checks.(number of checks vary from 1-40,in the example in the attachment consist with 10 checks)
The data according to relevant check is displayed in rows 11-16.(in the example, starting time of the check under check number 1 is displayed in cell C14).

What i need to do is, i have to organize the given data in ascending order in order to starting time.
As an example i have inserted some data for 10 checks.they are not in ascending order in order to starting time.Since the starting time under check number 2 is the smallest, all the data under check number 2 should be stored under check number 1.Since the starting time of the check under check number 7 is the next smallest,all the data under check number 7 should be stored under check number 2.this should be done for all the inserted data.

is there any macro or method that i can do above task successfully?
please help me to handle this problem
thanks

[Sadath31]

Try this VBA for vertical sorting.
select the range (C10:L16 in this case) and run the macro

VBA Code is below

Please Login or Register  to view this content.

[Sadath31]

one small correction
[a1] = [a1] + 1 < this line doen't required pls remove

[Sadath31]

It does not require this complication to sort left to right.
Excel have option to sort from left to right, You will find left right sort from the Sort Options.

Sorry for the complication.

[rsami]

It does not require this complication to sort left to right.
Excel have option to sort from left to right, You will find left right sort from the Sort Options.

Sorry for the complication.

thanks very much for your help.
actually i tried your Macro as well as sort from left to right.
both are work perfectly as i expected.
again thanks very much!!!