I'm guessing this can't be done seeing I never got a reply?

"John" wrote:

Hi all Im new to excel and was wondering if someone would be kind enough to
help me out.

The main worksheet consists of all the data, example: name and totals, I was
wondering if its possible when I create a new worksheet that it would list
the person name based on the highest to the lowest totals from the main
worksheet.

Main worksheet consists of:
Cell D2 :D60 = Names
Cell F2 :D69 = Totals

So in worksheet 2 it will automatically list the names based on the main
worksheet data is this possible?