Adding a Single Cell total from Seperate sheets

[GccTxs]

I am putting together a Workbook that tracks the performance of my sales
team. The work book has a seperate sheet for each salesman. Each sheet has a
column per week total for a 20 week period.

Which is not where the problem is, I have done all of this for each
salesman.

What i need to do is make a new sheet that does a couple of things,,,

It needs to list the total for each salesman in order of smallest to
largest, assign each position a point total and then send back to each
salesmens sheet a running point total....

A picture is worth a thousand words so here is a basic image.....(Picture
Columns)

week 1
Position....Salesman....Sales..........Points
1..............Tom...........100.00.......1
2..............Rick...........200.00.......2
3..............George......300.00........3

Etc

 

[Max]

Here's a link to a demo file (full construct details inside):
http://savefile.com/files/3813239
Sales Performance Tracking_GccTxs_wksht.xls

The demo file is a play using non-array formulas which attempts a possible
set-up to the scenario posed. For brevity in presentation, the weekly
totals set-up in each salesman's sheet is assumed to be row-wise rather than
column-wise. Other than this, the proposed set-up tries to closely sync
with what is posted / wanted ..

 

[GccTxs]

Thank You!!

Here's a link to a demo file (full construct details inside):
http://savefile.com/files/3813239
Sales Performance Tracking_GccTxs_wksht.xls

The demo file is a play using non-array formulas which attempts a possible
set-up to the scenario posed. For brevity in presentation, the weekly
totals set-up in each salesman's sheet is assumed to be row-wise rather
than
column-wise. Other than this, the proposed set-up tries to closely sync
with what is posted / wanted ..
--
Rgds
Max
xl 97

 

[Max]

You're welcome !