| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy data from a list
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy data from the top cell of a filtered list to anothe. | Excel Worksheet Functions | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| Copy row data based on drop down list selection | Excel Programming | |||
| Copy Data List | Excel Discussion (Misc queries) | |||
| copy data from a list to another sheet | Excel Programming | |||
Threaded Mode
