title: Find text and copy to another sheet
body: <p>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.</p>
  
  <p><a href="https://i.stack.imgur.com/MV8Xf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MV8Xf.png" alt="enter image description here"></a></p>
  
  <p>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.</p>