MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need a macro to do the "advances filter" function, how can I do ?

Posted by Laurent on October 08, 2001 5:43 AM


I'd like to do a macro for the "advanced filter" tool, so I can prepare several criteria ranges on a separate worksheet, and just click on buttons associated with these macros to apply the filter I need.

Could someone give me advice on that ? I'm really new to macroing in excel and I'm a bit lost. Any website with info on this topic is welcome too.



Posted by Juan Pablo on October 08, 2001 7:11 AM

If you want to learn, use the Macro recorder and to the steps you expect the macro to do. Then go to the VB Editor (Alt F11), and then you can view/edit/modify the macro that you just recorded.

Juan Pablo