Hi,
I have a file which has the following information in Column A :
[TABLE="width: 348"]
<tbody>[TR]
[TD="class: xl63, width: 348"]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
"
[/TD]
[/TR]
</tbody>[/TABLE]
I have a file which has the following information in Column A :
[TABLE="width: 348"]
<tbody>[TR]
[TD="class: xl63, width: 348"]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
"
[/TD]
[/TR]
</tbody>[/TABLE]