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:

[TABLE="class: outer_border, width: 200"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]16[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: center"]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: center"]triangle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: center"]blue[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: center"]square[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]21[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: center"]yellow[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: center"]diamond[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD="align: center"]red[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD="align: center"]circle[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]


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:

[TABLE="class: outer_border, width: 200"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: center"]red[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: center"]circle[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: center"]blue[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: center"]square[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]16[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: center"]green[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: center"]triangle[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]21[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD="align: center"]yellow[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD="align: center"]diamond[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]


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.