Solved: How to get the filter criteria automatically in AutoFilter

[lokwungkwung]

There are 2 workbooks. My task is to have the macro to extract the filter criteria automatically in workbook A,then based on the criteria to filter the data in workbook B master sheet and display the filtering in workbook B result sheet. Macro is recorded in workbook B already but criteria is manually input .

[david000]

http://www.ozgrid.com/VBA/autofilter-criteria.htm