View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tommy
 
Posts: n/a
Default results on sheet 2

I have golf program I am working on. Here is the setup

column a b c d e
f g h
player 1 score score total player 1 score
score total
player 2 " " " player 2
" " "
Player 3
Player 4
Player 5 " " " player 5
" " "

That is an example of the first page, it hase 3 other teams under the ones
above.
I want to enter a score and without using a macro if possible the score and
total automatically go to sheet 2 in order from lowest score to highest. i
want this to happen everytime I enter a score. Is this possible.

thank you