Transferring function results to another sheet

K

KaKa

How do I get excel to transpose the answer from a formula on the first sheet
and display it on sheet 3?
 
D

Dave Peterson

Maybe the worksheet function =transpose()
or edit|copy followed by edit|paste special|Transpose
 
K

KaKa

On sheet 1 & 2, I enter names and scores. On sheet 3, I want to be able to
list the top 10 scores with their names, as well as keep track of how much
money was paid out to them.
 
Top