Hi,
I have a file which has the following information in Column A :
<tbody>
</tbody>
I have a file which has the following information in Column A :
Project: ABC 1 34 45 Total Project: XYZ 3 56 Total I would like to all rows which do not contain "Project:" or "Total" to be deleted IN this case, the final output should look like this : Project :ABC Total Poject:XYZ Total. I was looking for VBA code to do this. I tried something like the following but did not work exactly as I wanted : " For i = 1 To 500 ' Revise the 500 to include all of your values If InStr(Cells(i, 1).Value, "Project:") = False Then ws.Rows(i).EntireRow.Delete End If Next i " |
<tbody>
</tbody>