How to us macro for designing a statistic table (i.e soccer score table) auto update after i enter t

[felixt996]

Hi anyone out there..

i need help on this.. i ran out of idea n clue to to use macro to
calculate, sort n display the winner in the soccer score stat.
spreadsheet..i m a newbie in excel.. learn some VB before..

i hope you know what i m talking bout..

thanks

 

[Guest]

Select the data and do Data=>Sort from the menu. Specify the score column
and whether to sort ascending or descending. Make any other appropriate
choices.

No macro needed.

 

[felixt996]

Select the data and do Data=>Sort from the menu. Specify the score column
and whether to sort ascending or descending. Make any other appropriate
choices.

No macro needed.

--
Regards,
Tom Ogilvy








- Show quoted text -

will it sort the whole row?
i wan the whole row to be swap according to the score..
can i do that?

thanks

 

[Guest]

if you select only a single cell in the data, then that will be the default
behavior.

To be sure, select all the data you want to sort before going through the
menu.