Sort automatically?

[RickeyS]

I have a spreadsheet that keeps track of overtime hrs worked, which based on person with lowest hrs I can assign the next overtime to the person with the lowest hrs. When I put in hours worked I have a column that keeps a running total.
Here's what I need:
Once I enter someone's hours and it auto sums I want the sheet to automatically resort for lowest hours (running total). How would I do this?
Thanks
Rick

 

[Smitty]

Put Application.EnableEvents = False at the beginning of the code and Application.EnableEvents = True at the end.

That will prevent that recursive recalculation.

Smitty

 

[KWD]

That works perfectly!!

Thanks!