Quick VBA Help

[Nerdalert314]

Below is the code I have now.

I need it to be

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif] With Sheets("Cash Update Data")
.Range("O1").AutoFilter 15, "12" Everything not including "#N/A"
.AutoFilter.Range.Offset(1).EntireRow.Copy Sheets("QTD").Range("A2") QTD is in another workbook
.AutoFilterMode = False
End With[/FONT]

    With Sheets("Cash Update Data")
      .Range("O1").AutoFilter 15, "12"
      .AutoFilter.Range.Offset(1).EntireRow.Copy Sheets("QTD").Range("A2")
      .AutoFilterMode = False
   End With

 

[James006]

Hello,

Sadly you have only posted a portion of your macro ...

If you have declared a variable for your second workbook ... you just need to place it in front of sheets("QTD")

Hope this will help