Automated Sort

  • Thread starter Thread starter Ed H
  • Start date Start date
E

Ed H

I have spreadsheet that I would like to be automaticly
sorted with out updating each category.

Basically I have fantasy football..

Each week the scores changes..

The top players are listed on a separte spreadsheet and
it divided into positions. But I have to go to QB
category and sort to get the highest score each week. I
want it always to sort.
 
Next time you sort your data, record a macro when you do it. You may need to
tweak it a little and if you need help, post back.

But then on your qb section and put a button from the Forms toolbar near it.
Assign your recorded macro to that button. Then when you want it sorted, just
click the button.

(I think that this would be better than automatic. I wouldn't want my list
sorted when I was doing the actual data entry.)
 
Back
Top