Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter for 4 criteria only need data from one column
Excel 2003 new to VBA in Excel.
Database data in worksheet All A1:M13679. Row one is header fields. Need to filter on columns B,C,D, and K. Need to put data from column L in a different workbook. Another sheet has the Criteria in A1:D409 The data is sorted the way I need it, by school, subject, grade, and quartile. Those are the filter criteria. How can I copy only the filtered data from L? When I used Advanced Filter, it would not let me specify the non-contiguous coumns. I can copy the filtered data in B:K to O:Y then copy Y and paste to other workbook. I'll be looping through the data on Criteria sheet and forsee some problems there too. Thank you for your help with this project. Georgie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter duplicates based on criteria / column values | Excel Discussion (Misc queries) | |||
Run Filter criteria based on data in range | Excel Discussion (Misc queries) | |||
filter or format based on criteria in more than one column | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Filter column using criteria from a userform | Excel Programming |