Hello:
I have data that is inserted weekly into a new worksheet in the same
workbook. This data is aggregated into a single worksheet. The final
worksheet is 2 columns. Column A has the person's name, and Column B has the
total for the person. I have a macro set to automatically sort by Column B
when the worksheet is selected.

What I would like to do is have a third column that would tell me how many
spots an individual gained or lost from the previous week. I would like for
this process to happen automatically when the worksheet is selected if
possible. For example:

A B C

John 27 +3
Sallie 31 -1


Any ideas?

Thanks.....