All of the world cup spreadsheets that I have seen are all very complicated,
probably due to in part the authors trying to give them a special look and
feel associated with Germany 2006.

I have a league table which uses VBA, but I will try and adapt it over the
next few days to be VBA free. If you send me your email address I will
notify you if and when it is done.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gdh82" wrote in
message ...

Thanks Topper and Bob Phillips for your replies - its much appreciated.

You can do it if you are prepared to have the sorted data as a separate
table, so you have one data capture table unsorted, one sorted display.

How complicated should this be, Bob ? Only the worldcup spreadsheet
seems to have 27 versions of the table (over a 9-page worksheet) which
I imagine are at varying stages of sorting? This seems too complicated
? Would you happen to know of a simpler spreadsheet by any chance ?


--
gdh82
------------------------------------------------------------------------
gdh82's Profile:
http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213