View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Excel Formula Help

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?