Excel Macro Question.
I am trying to build a macro in a excel spreadsheet to save me a bunch of time. I have recorded the following macro.
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.
' DailyUpdate Macro
ActiveSheet.ListObjects("Table42").Range.AutoFilter Field:=1, Criteria1:= _
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.