Sorting Data into Time order using a String header

Hi,

I hope the "before" (sheet1) and "after" (sheet2) examples on this workbook explain what i need help with.

Sort before after example1.xlsm

Each day i run this the header name will be different but there will always be a time figure after the header which is what i want to sort by.

i.e
Sams house 1:35
Jims park 12:55
Janes garden 14:30

Thanks in Advance

I tried so hard to get the example identical to the data I'm using but had a fail with the amount of rows within headers

It is variable.... sorry.


Also even with the current example it doesn't rearrange the code correctly.

Would it also help to know that each header is always a merged cell (ABC) and the data within each header is always over 3 columns,

Header always contains a *:**


Thanks

Pl attach file similar to your original data with all variations.

This is more like the data I'm working with


Sort before after example2.xlsm

Pl see the attached file. The number of rows between headers will not matter.Hope your requirements are met. If so mark the thread solved.
Sorry for the delay.

That's amazing thanks.

Thanks.pl click on the star below .