J
john.9.williams
I wish to extract data from a range that meets certain critera and
place it on another part of my spreadsheet, I am using a simple filter
and copy and paste, was wondering if I could do it with out activated
the sheet, heres what i am using at the mo
CST = Range("D7")
Application.ScreenUpdating = False
Workbooks.Open Filename:= _
"http://10.234.95.121/Complex_Job_Lists/Wlr3/PreCalling.csv"
Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:=CST
Range("A2:l54000").Select
Selection.Copy
Windows("end user calling list ver8.xls").Activate
Sheets("database").Select
Range("B15").Select
ActiveSheet.Paste
Range("B4").Select
Range("A15:A1000").ClearContents
Range("A14").Select
place it on another part of my spreadsheet, I am using a simple filter
and copy and paste, was wondering if I could do it with out activated
the sheet, heres what i am using at the mo
CST = Range("D7")
Application.ScreenUpdating = False
Workbooks.Open Filename:= _
"http://10.234.95.121/Complex_Job_Lists/Wlr3/PreCalling.csv"
Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:=CST
Range("A2:l54000").Select
Selection.Copy
Windows("end user calling list ver8.xls").Activate
Sheets("database").Select
Range("B15").Select
ActiveSheet.Paste
Range("B4").Select
Range("A15:A1000").ClearContents
Range("A14").Select