Copying certain instances to another sheet.

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.

Maybe:

Sub GrahamPall()
Dim i As Long
With Sheets("BACKLOG")
For i = 2 To .Range("B" & Rows.Count).End(3).Row
    If .Cells(i, "B") = "CH01_CONVERTING" Then
        .Rows(i).Copy Sheets("CONVERTING BACKLOG").Range("A" & Rows.Count).End(3)(2)
    End If
Next i
End With
End Sub

Sweet! Thanks John. Is there anything that can be included to keep the formatting of the first sheet on the second sheet?

Can you attach a sample file with some dummy data to test on?

Only just got to have another look at this. Turns out there's no need, just recorded a small macro using format painter, and copied and pasted in, but thank you anyway John.

John, can you recommend a good book/website for learning VBA for someone who already has a pretty solid computing background and want to use it in a manufacturing environment, producing reports/lists/figures etc.

Graham:

This thread from the Forum should be of help.

http://www.excelforum.com/excel-prog...materials.html

Thanks John, much appreciated.