MS Excel / VBA help thread

Right.
Currently tearing my eyes out of this.

I have a number of schools. I know the age range of the students.
e.g.
0 - 11
low age = 0
high age = 11

I have categories
PreReception
Reception
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7 Yr 8 Yr 9 Yr 10Yr 11Yr 12Yr 13
FE/HE

these are
Min age Max age Median
0 3 1.5 PreReception
4 5 4.5 Reception
5 6 5.5 Yr 1
6 7 6.5 Yr 2
7 8 7.5 Yr 3
8 9 8.5 Yr 4
9 10 9.5 Yr 5
10 11 10.5 Yr 6
11 12 11.5 Yr 7
12 13 12.5 Yr 8
13 14 13.5 Yr 9
14 15 14.5 Yr 10
15 16 15.5 Yr 11
16 17 16.5 Yr 12
17 18 17.5 Yr 13
18 99 58.5 FE/HE

what i want to do is quickly populate

school name and all the categories it will have based on the age range.

e.g.
School Age rangePreReception Reception Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7 Yr 8 Yr 9 Yr 10 Yr 11

     0 - 11 0   TRUE                        TRUE             TRUE   TRUE    TRUE    TRUE    

I've got some inkling about median and something.

Or is there an iterative thing?
or?