Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sheets("Copy PAP into here").Select
- ActiveSheet.range("$A$1:$P$66").AutoFilter Field:=13, Criteria1:="#N/A"
- Sheets("copy pap into here").range("A1:C50").SpecialCells(xlCellTypeVisible).Copy
- Destination:=sheets("HPE").range("C" & Rows.Count).End(xlUp).Offset(1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement