title: find value from specific column and copy those rows from multiple sheets and paste in a different sheet serially
body: <p>I want to copy a specific data from a specific column and if that value(s) is found copy those rows and paste in a different sheet. I have near about 150 different files from which I will find specific value and paste in different sheet vertically and serially. please help me to do that. for example if "abc" value is found from column C 4/5 times then copy those rows and paste in sheet2 starting from cell A2.then same will happen from the next sheet. I have a code but it is not working properly.</p>
  
  <pre><code>Dim i As Long
  Dim test As Worksheet
  
  Set test = ThisWorkbook.Worksheets("Sheet3")
  
  For i = 1 To Cells(Rows.Count, "C").End(xlUp).Row
      If Cells(i, 3).Value = "Local7.Critical" Then
          Range(Cells(i, 1), Cells(i, 14)).Copy Destination:=test.Range("A" &amp; test.Cells(Rows.Count, "A").End(xlUp).Row + 1)
      End If
  Next i
  </code></pre>