I have tried to make head and tails of a few searches to delete entire rows, but I cant seem to adjust the coding to make it work for my scenario.
I have a row range 5:20004. In that row range column R may have 'QLD' in the cell.
I am trying to delete all rows within that range that have QLD in column R or delete the row if R <> 'NSW' (would be a better way just in case there is something other than QLD)
I would love to do this on opening the file automatically.
Can anyone offer up some help?