Data Filter Tool Add-in Update
March 11, 2008 – 7:05 pm by JP
Here is the screenshot of the Data Filter Tool I promised (sorry it’s late!):
I have been doing a lot of testing, refining the code, etc.. and it seems to be working well. I expect to release this add-in within the next week after some final testing.
Enjoy,
JP
Print This Post
|
Email This Post
|
Permalink
|
Filed Under: AddIns, Excel, VBA
Tags: addin, autofilter, Excel
This post has 23 views since March 11, 2008 – 7:05 pm.







3 Responses to “Data Filter Tool Add-in Update”
Looks good! How will it deal with formulas and formatting? Say I have some values that have been generated using formulas, is there an option to move them as values only, or as formulas with full formatting?
By mary on Mar 13, 2008
Good point Mary. It isn’t really intended for moving formulas, I’ll have to test it and decide if I want to add that functionality. Formatting should be unaffected, but again I’ll have to test that as well.
Thx,
JP
By JP on Mar 13, 2008
Mary, I checked and it copies over formatting, but the formulas are pasted as values. I decided I’m going to leave it that way (for now) and maybe create a new sorting/filtering routine in the future if the data contains formulas.
By JP on Mar 24, 2008