Sort groups of cells into numerical order

[jock444]

Hi, I would appreciate any help on how to write some code to sort groups of cells I have into numerical order. The cells are grouped like this:

	A	B
1	15	16
2	green
3	triangle
4
5	11	12
6	blue
7	square
8
9	20	21
10	yellow
11	diamond
12
13	7	8
14	red
15	circle

<tbody>
</tbody>

The numbers are start and end times so I would like to sort the cells by the first number in each group (cells A1, A5, A9, A13 in my example) so the result should be this:

	A	B
1	7	8
2	red
3	circle
4
5	11	12
6	blue
7	square
8
9	15	16
10	green
11	triangle
12
13	20	21
14	yellow
15	diamond

<tbody>
</tbody>

I'm new to coding so really not sure the best way of doing it. The groups of cells are all named ranges if that makes it simpler? Many thanks!

 

[DanteAmor]

It can be with a formula and ordering the table.
For example, create an Auxiliary column and write the formula in C2 as shown in the following example, then copy down.

Book1
	A	B	C
1	DATA 1	DATA 2	AUX
2	15	16	15
3	green		15
4	triangle		15
5			15
6	11	12	11
7	blue		11
8	square		11
9			11
10	20	21	20
11	yellow		20
12	diamond		20
13			20
14	7	8	7
15	red		7
16	circle		7
Hoja4

Cell Formulas
Range	Formula
C2	=IF(ISNUMBER(A2),A2,C1)

Now sort the table by the auxiliary column from lowest to highest

Book1
	A	B	C
1	DATA 1	DATA 2	AUX
2	7	8	7
3	red		7
4	circle		7
5	11	12	11
6	blue		11
7	square		11
8			11
9	15	16	15
10	green		15
11	triangle		15
12			15
13	20	21	20
14	yellow		20
15	diamond		20
16			20
Hoja4

 

[jock444]

Thanks Dante, that's a simple solution which should work well for what I need. Appreciate your help again .

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.