Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: Use the autofilter result on one workbook to filter the next list on another workbook
Hi All,
Is it possible to extract the filtered result after using the AutoFilter and use this list to be the filter criteria on another worksheet. So for example: on the first worksheet - filter for all failed (grade <= D+) students on one paper on the next worksheet - get the filtered list on the 1st worksheet and automatically use this list to custom filter the next list, so it will display all the failed students past grades history Can this be done? Cheers Kathy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP: Use the autofilter result on one workbook to filter the next list on another workbook | Excel Worksheet Functions | |||
Sum data in workbook 1 and write result in workbook 2 | Excel Programming | |||
Code to Advance filter a list in a shared workbook | Excel Programming | |||
Get the list from Autofilter after filter some criteria | Excel Programming | |||
Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions |