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

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

How to us macro for designing a statistic table (i.e soccer score
 

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



" wrote:

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

How to us macro for designing a statistic table (i.e soccer score
 

On Jul 7, 11:08 am, Tom Ogilvy
wrote:
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



" wrote:
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- Hide quoted text -

- 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

How to us macro for designing a statistic table (i.e soccer sc
 

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.

--
Regards,
Tom Ogilvy


" wrote:

On Jul 7, 11:08 am, Tom Ogilvy
wrote:
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



" wrote:
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- Hide quoted text -

- 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