Looking up data in a price file

[Klartigue]

I have data laid out in an excel table. In column B, there is either an "S" or "B" in each cell. I would like to write a macro that selects only the rows with an "S" in column B. I am unfamiliar with how macros work when an excel table is invovled.

Any help is greatly appreciated.

Thanks!

[Aussiebear]

"Solved"...... How? Since no solution has been provided by others, can I assume you finally realised that Excel's Filter function does exactly what you asked for.

As someone posting a thread in a public forum, could you please supply the "solution", then mark it as Solved, rather than just hide behind the options provided by the forum.

[Klartigue]

Sub EvalPriceLookup()
'
' Look up eval price
'
Windows("Volume.xlsx").Activate

With ActiveSheet

LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row
For i = 2 To LastRow

If .Cells(i, "B") <> "B" Then

.Cells(i, "J").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],pricefile.xlsx!R1:R1048576,2,FALSE)"

End If
Next i
End With

[Aussiebear]

Thankyou

[mdmackillop]

Get rid of the Select
.Cells(i, "J").FormulaR1C1 = "=VLOOKUP(RC[-4],pricefile.xlsx!R1:R1048576,2,FALSE)"