View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
debra49424 debra49424 is offline
external usenet poster
 
Posts: 6
Default Auto Sorting Data in Table

Have a table that totals training points that we are manually sorting by
percentage of total points (difference between points earned and possible
points).

Looking for a way to have the table auto sort by the percentage when the
total points change. The chart is set up as follows:

Column B Column C-AG Column AH Column AI Column AJ
Names Points are entered Points sumed Possible Points % of
Possible Points

What I need it to do is when the points summed changes (which changes the %)
that the table automatically sorts the table from highest % to lowest % in
Column AJ.

Any suggestions/ideas are greatly appreciated.
dbarrow