I have a spreadsheet that I receive weekly and perform the same "data cleaning" tasks. Being a beginner Excel VBA user, I am impressed with what I've been able to accomplish so far but I have reached a roadblock. I am trying to delete certain rows from the file. The file contains data in a page-like format so when the home system exports it to me, I have a footer at the bottom (or every 45 rows or so). I would like to filter based off the wildcard text "Loss" which is in each row, and delete these rows.
I tried this but it did not work
Selection.AutoFilter field:=1, Criteria1:="*Loss*", Operator:=xlAnd
Any help would be greatly appreciated.