Hi all,

I have realised my previous request was a bit complicated and a bit tricky to understand without seeing the actual spreadsheet itself and what I was trying to achieve, and I have realised I was going about it the wrong way.

What would be easier, is to copy the relevant information to the right sheet in the first place, instead of trying to delete off erroneous data after the fact.

So, would someone be able to provide me with a small macro that......

Copies all instances of "CH01_CONVERTING" in Column B to a on a sheet called "BACKLOG" to a new sheet (called CONVERTING BACKLOG), using an IF command (or any others if they work better?). It doesn't necessarily need to copy the header row, as that can be added afterwards.

Many thanks in advance.