PDA

View Full Version : Solved: How to get the filter criteria automatically in AutoFilter



lokwungkwung
12-14-2008, 03:38 AM
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
12-15-2008, 10:15 AM
http://www.ozgrid.com/VBA/autofilter-criteria.htm