G
Georgie
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
409 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
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
409 The data is sorted the way I needit, 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