Hi Gary,
the sort range isn't a problem, the problem seems to occur because of the
formulas when I sort.

For example: I have 13 worksheets so far (one for every week of the season,
RegularSeason W1,RegularSeason W2, etc...) then I have one called
OverallTotals (which is the cumulative of all the weeks) the formula for the
column called "Total score" for example is:
=SUM('Regular Season W1'!E3,'Regular Season W2'!E3,'Regular Season
W3'!E3,'Regular Season W4'!E3,'Regular Season W5'!E3,'Regular Season
W6'!E3,'Regular Season W7'!E3,'Regular Season W8'!E3,'Regular Season
W9'!E3,'Regular Season W10'!E3,'Regular Season W11'!E3,'Regular Season
W12'!E3,'Regular Season W13'!E3).

When I perform a SORT by any column, the numbers don't follow the
appropriate rows (name of the players).

Any idea?

I've been using Excel for years to do a lot more complexe spreadsheets than
this, and this is the first time I encounter a problem of this nature!

"Gary Brown" wrote:

Sounds like your sort range isn't including all the columns so some columns
stay put and others move.
Ouch!
Make sure you have all the columns in your database in your sort range.
HTH,
Gary Brown

"LineRicher" wrote in message
...
I have a created a workbook to keep stats on a small dart league. For some
reason I'm have problems when I sort. Its like the information isn't
locked
in. The formulas are assigned to cells, but when I perform a sort, its
not
assigned to the right person! Not sure how to explain it properly, but if
someone has any clue what I'm talking about, can you email me at


Please and thanks