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.
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..........:smile:
Thanks in advance.
Sub DailyUpdate()
'
' DailyUpdate Macro
'
'
ActiveSheet.ListObjects("Table42").Range.AutoFilter Field:=1
Range("A2:K2").Select
Selection.Copy
Range("A49").Select
ActiveSheet.Paste
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..........:smile:
Thanks in advance.