Data Filter Tool Add-In – Coming Soon
March 5, 2008 • JP • No Comments • Rate This Article
• Links to this article
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
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Website Parsing/Retrieval using XML
Next Post: Data Filter Tool Add-in Update
Sorry, comments for this article are closed at this time.