Hi,

I have an excel spreadsheet that has data in the format (sample):

Date      Customer      Qty         Price       
12/1      AAA           10           1 
12/2      BBB           10           2 
12/2      CCC           15           8
12/3      CCC           12           9

I need a macro that will go through and delete all rows where customer
does not equal "BBB".  The final result should be a sheet with all
transactions of only customer BBB with the relevant data.

Thanks very much for your help

If you're not set on a macro, this can be done in about 20 seconds for
any size sheet:

1) Highlight the title row
2) Click on "Data" "Filter" "AutoFilter"
3) Click on the down arrow in the "Customer" cell
4) Select "Custom"
5) Select "Does not equal" and in the other box type "BBB"
6) Delete all rows below the title row
7) Click on "Data" "Filter" "AutoFilter" (to turn off the filter)

'Change column "B" in "Range("B65536") to your client column.  Then
run the macro.  It will error out when it gets to row one.  But this
will delete out all clients not "BBB".  If you want me to write a
macro where it counts the row and stops on row one, please ask.
 
Sub DeleteIt()

Range("b65536").End(xlUp).Select
Do
    If ActiveCell.Value <> "BBB" Then
        Selection.EntireRow.Delete
    Else
        ActiveCell.Offset(-1, 0).Select
    End If
Loop

End Sub

I vote for the AutoFilter route here.  A macro is overkill when this
is accomplished so easily with built-in functionality.