I am filtering for a code and deleting in a worksheet, i recorded a macro to do this. I have attached the code.
You can see my problem here is that if i do this tomorrow and there are entries anywhere above 36, it wont delete them.
I cant select the whole sheet and delete as i need the headers
How can i delete all rows based on that selection
Selection.AutoFilter Field:=7, Criteria1:="MDBKIDQ"