You will need to make some backwards loops and call the cell through the use of 'Cell' and not 'Range', see below to loop through your range backwards. (P.S. Do not use merged cells unless your life depends on it)
Sub test()
Dim x As Long, y As Long
For y = 15 To 7 Step -2
For x = 42 To 17 Step -1
Cells(x, y).Select
Next x
Next y
End Sub
You could use something like the above to create a function to write to the range backwards, you could then just call the function each time you wish to write to your backwards tables. Function example below:
Sub test()
RevCell 42.6666
End Sub
Function RevCell(str)
Dim x As Long, y As Long
For y = 15 To 7 Step -2
For x = 42 To 17 Step -1
If Cells(x, y) = vbNullString Then
Cells(x, y) = str
Exit Function
End If
Next x
Next y
End Function
Hope this helps