Refresh Autofilter when data is added?

[HC1994]

Hi guys,

So I have a column, say column A, that I have a auto filter assigned. I would like it to auto-refresh the filter every time I add in data at the end.

I found this macro, but it only works for changes made within the filter, not if I add in data at the end.

http://www.ozgrid.com/forum/showthread.php?t=59917

Private Sub Worksheet_Calculate()

If Me.FilterMode = True Then
With Application
.EnableEvents = False
.ScreenUpdating = False
End With

With ActiveWorkbook
.CustomViews.Add ViewName:="Mine", RowColSettings:=True
Me.AutoFilterMode = False
.CustomViews("Mine").Show
.CustomViews("Mine").Delete
End With


With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End If

Please let me know if you guys can help me out!