Sort Automatically

[sn152]

Hi All,

In the attached workbook, in sheet 1 I have the data. The columns B,C,D,E,F contains the scores. And columnG contains the Sum of those scores.

When I change the score on column B, C, D, E, F, it automatically Sums the score in Column G.

Now what I want is whenever the score changes in column G, it should automatically sort (descending) the entire range.

Please find the attached.

Please help me with this. Thanks in advance.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[sn152]

Hi Narayan,

This works well. Thank you....