15th January 2013, 02:16 PM
|
|
Banned
|
|
Join Date: Jan 1970
Posts: 879
|
|
benton, it may make things easier allround to delete out all the place records prior to using bf's data
The code below does the job, let me know if you need instructions on use
Code:
Sub delete_place_records()
Dim lst As Long
Dim i As Long
lst = Range("E" & Rows.Count).End(xlUp).Row
For i = lst To 1 Step -1
If Range("E" & i).Value Like "TO BE PLACED" Then
Range("E" & i).EntireRow.Delete
End If
Next i
End Sub
|