auto filter on adding rows

[Paul_Hossler]

Hi Paul

Thanks for the help. when I paste the new rows at the bottom it doesnt sort it into alphabetical order. Am I missing something? Also is there a way to add two combo boxes to filter for a specific date range?

1. Did you exit and return to the data sheet? The way I have the sort is that it only runs when entering or exiting the worksheet, and only if EnableEvents = True

From Post #4

Private Sub Worksheet_Activate() 
    Call SortData(Me) 
End Sub 
 
Private Sub Worksheet_Deactivate() 
    Call SortData(Me) 
End Sub

2. I added Bill in row 22, went to Sheet2, and then back

Capture.JPG

3. The event can be changed to Worksheet_Change, but that seemed like too many firings