I have a Log file which I have imported to Excel and I have filtered Col C based on a Criteria. Now I want to search through Col E for "TRUE". For every instance of "TRUE", I want to select the rows above it for Col D,E until I find an empty cell in Col E, copy those and paste it into a new worksheet in the same workbook.
As per the picture above, I want to copy Rows 9 to 1 in worksheet1 and Skip copying Rows 20 to 10 (Because Col E has FALSE) and copy rows 31 to 21 in worksheet2.
You can use .areas
This is a tough one if you have no VBA experience and don't know what to look for. Here is a head start, based on the picture you have supplied I came up with this.
Sub DoIt() Dim sh As Worksheet, ws As Worksheet Dim RangeArea As Range, c As Range Set sh = ActiveSheet Application.ScreenUpdating = 0 With sh For Each RangeArea In .Columns("E").SpecialCells(xlCellTypeConstants, 23).Areas Set c = RangeArea.Find(what:="TRUE", lookat:=xlWhole) If Not c Is Nothing Then RangeArea.EntireRow.Copy Sheets.Add ActiveSheet.Paste Else End If .Select Next RangeArea End With Application.CutCopyMode = 0 End Sub 
Loopto run thought the columns and theIfyou find what you are looking for start anotherLoopto search up for the required text. Then assign that Range and copy it to the new sheet.