Macro to create a League Table which will automatically update.

**rushdenx1** · 01-31-2012, 05:31 AM

The enclosed file contains data which is added to on a daily basis. It shows work done by individuals on shifts. I would like to be able to show a League Table of the people which automatically updates based on the various columns. I have manually produced the stats for one individual on the sheet, but would like this to be produce for all the individuals automatically and shown in descending order based on AVGE % DONE. I have added some comments to help explain where the data comes from. Any help is appreciated. Kevin

**Kyle123** · 01-31-2012, 05:39 AM

A Simple pivot table will do this, see attached

**rushdenx1** · 01-31-2012, 08:52 AM

Thanks for your help. However, the numbers in the Pivot Table for Disputed and Missed is wrong for each individual. As an example M.Wyles shoud be 6 Disputed and 8 Missed. A.Appleton should be 0 Disputed and 11 Missed.