Hello
I am using this macro to find, copy and paste rows where column E contains 0.1. I would like to adapt it so it also finds, copies, pastes rows where column E contains 0.11, 0.12, 0.13.
How do I amend it to make it work?
Thanks
I am using this macro to find, copy and paste rows where column E contains 0.1. I would like to adapt it so it also finds, copies, pastes rows where column E contains 0.11, 0.12, 0.13.
How do I amend it to make it work?
Thanks
VBA Code:
Option Explicit
Sub ParseData()
Dim Cell As Range
With Sheets("ResultsData")
' loop column E untill last cell with value (not entire column)
For Each Cell In .Range("E1:E" & .Cells(.Rows.Count, "E").End(xlUp).Row)
If Cell.Value = "0.1" Then
' Copy>>Paste in 1-line (no need to use Select)
.Rows(Cell.Row).Copy Destination:=Sheets("ParsedData").Rows(Cell.Row)
End If
Next Cell
End With
End Sub