Selected Answer
Please try the code in the attached workbook. On the ribbon's?Developer tab click Macros, select CreateFilteredList and press Run. The macro will create a sheet with the rows from the Data tab specified in the NamedRange range and call it Result.
To import the macro into your own workbook just drag the entire code module FilteredList into your own VBA project in VBE's Project Explorer while both workbooks are open. You can also copy the code and paste it into a blank code module in your project?(the name isn't significant). There are instructions for adapting the code to your own encironment at the top of the macro. All changes are contained within 5 constants, fully explained and easy to understnad. Let me know if you need more help.