World Cup 2010 Tracker

Hi,

I thought my Excel knowledge was decent, but I am really struggling with this one.

Basically I have found a World Cup 2010 template that I would like to customize to fit my own little football tournament.

My problem is that in WC2010 there are 4 teams in each group - and in my own there is 5 teams. So basically I just want to add 1 more team to each group. Sounds easy right...

The are a couple of obsticales:
1. There is auto sorting by macro which needs to be adjusted in Visual Basic?
2. In the sheet 'Calculations' there are several options in case of ties, etc. which also needs adjusting to 5 teams?

I have tried the best I can to get the codes sorted out in the 'Calculations' sheet, but I am now stuck

I would appreciate if anyone have time to have a look and help.

I have attached the original and the one I have altered (maybe messed up? )

Thanks a million in advance

Michael