Take a look at http://xldynamic.com/source/xld.Leag...e.html#sansVBA

--
HTH

Bob Phillips

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

"Saky" wrote in message
...
Hi! I'm working on some soccer statistics in Excel 2003. So fare, I
make I fixture list, and a table. Table automaticly updates when you
input a result for a match. That works fine, but I cant sort my table.
When I sort it, formulas in each row changes so I get wrong table.

1. How can I make a table to sort, but not to change formulas?
and
2. How to make that same table to automaticly updates it self when you
enter a result in a game?

Thank for help!