I am trying to build a macro in a excel spreadsheet to save me a bunch of time. I have recorded the following macro.

Sub DailyUpdate()
' DailyUpdate Macro

ActiveSheet.ListObjects("Table42").Range.AutoFilter Field:=1
ActiveSheet.ListObjects("Table42").Range.AutoFilter Field:=1, Criteria1:= _
End Sub
In the highlighted cell, instead of it picking A49, I would like it to fill the line following the one I did prior each time I run the macro. So today it was in A49, tomorrow it will be A50, then A51 and on and on.

Does anyone know a simple fix for this problem. I have gotten a lot of excel help on this here forum and have great confidence that it will continue..........

Thanks in advance.