To Whom May Wish to Assist:

I have multiple tables in one Excel 2002 worksheet. The tables are
"paste linked" and/or include formulas (sums, averages, percent
changes) and change when a single column of data in a separate table
is updated.

For example:

Table I. of formulas:

A B C D E F G
X1 X2 X3 X4 X5 Avg
1) Alice B6/x C6/x D6/x E6/x F6/x G6/x
2) Colin B7/x C7/x D7/x E7/x F7/x G7/x
3) Brett B8/x C8/x D8/x E8/x F8/x G8/x

Table II. of paste linked data:

A B C D E F G
X1 X2 X3 X4 X5 X6 Totals
6) Alice 8 5 3 7 $B$11 Totals
7) Colin 4 3 7 8 $B$13 Totals
8) Brett 9 6 2 1 $B$12 Totals
9) Totals Sum Sum Sum Sum Sum Totals
10) Averages Avg Avg Avg Avg Avg Avg

Table III. Entered Daily:

A B
11) Alice 8
12) Brett 5
13) Colin 3

I wish the "Average" column result in Table I. and the "Totals" column
result in Table II. to auto-sort in descending order upon the data in
Table III. being updated.

Advice?

Thanks in advance,
Corinne