title: VBA copy after Criteria in other file
body: <p>I must copy after 3 column , for 3 Region - which have an X on rows if my info are for NAFTA,Europe and Asia.The info should be copy from MasterDate -MacroMaster file to Prices_Database_ For_ Volume_Europe.I create below code for Europe but don't work and don't generate any error.Please advise.</p>
  
  <pre><code>Sub Copy_Data_From_Macro_FileinDB() ' copy data from Macro file to DB file 
      Dim wsCopy As Worksheet
      Dim wsDest As Worksheet
      Dim lCopyLastRow As Long
      Dim lDestLastRow As Long
      Dim i As Integer
  
      For i = 2 To lCopyLastRow
  
      If Cells(i, 11) = "EU" And Cells(i, lCopyLastRow) = “x” Then
       Set wsCopy = Workbooks("MacroMaster file.xlsm").Sheets("MasterData")
       Set wsDest = Workbooks("Prices_Database_ For_ 
       Volume_Europe.xlsx").Sheets("MasterData")
  
       lCopyLastRow = wsCopy.Cells(wsCopy.Rows.Count, "A").End(xlUp).Row
       lDestLastRow = wsDest.Cells(wsDest.Rows.Count, "A").End(xlUp).Offset(1).Row
  
       wsCopy.Range("A2:AB" &amp; lCopyLastRow).Copy _
       wsDest.Range("A" &amp; lDestLastRow)
  
       Workbooks("Prices_Database_ For_ Volume_Europe.xlsx").Close 
       SaveChanges:=True
       Workbooks("MacroMaster 
       file.xlsm").Worksheets("MasterData").Range("A2:AB100").ClearContents
       End If
  
       Next i
   End Sub
  </code></pre>