Thanks for the help with the previous query, but can anyone help me with this one? I need it to search through a sheet and every time it finds "Operator:" in a cell I need it to delete the 6 rows ABOVE it. There will be multiple occurences so I need it to loop until the sheet is clean
If it helps, it will only appear in Column A but it could be any number of times
Janie
If it helps, it will only appear in Column A but it could be any number of times
Janie