I am working on an Excel add-in called 'Data Filter Tool' that lets you auto-filter a range and copy or move matching rows to a new workbook. It is similar to Ron de Bruin's EasyFilter (EasyFilter Add-In), but much simpler and easier to use (in my opinion) because it is a single purpose tool.
I decided to write this add-in because copying matching rows to a new worksheet seems to be requested in both in the Excel newsgroups and in "real life" over and over. Hopefully this will aid some of those people who are looking for an easy automated solution.
First you would select your range (via RefEdit Control) then specify the column and data item you want to filter (in separate combo boxes). You can specify if you want the rows moved or simply copied. Click 'Apply' and the add-in copies or moves the matching rows to a new workbook.
This tool will be available for download from this website, and the release announcement will be posted on The Coding Pad (The Coding Pad) for which I will be doing a guest post.
I'll post a screenshot of the userform later today or tomorrow.
Enjoy,
JP
About JP
Follow Me