sn152
Member
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.
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.