Seven Excel add-ins are now available!
- Data Filter Tool
- Sheet Picker
- Shipment Tracking
- Shipment Tracking Userform
- Random Data Generator
- Amazon Ad Link Generator
- Clean And Trim Cells
The add-ins and files available on this site may not be redistributed without permission. If you find these add-ins on another site, I would appreciate if you would let me know.
For more information about these addins, read the FAQ.
Compatibility
ShipTrack, Amazon Ad Link Generator and Cell Trimmer are compatible with 32-bit Office from Excel 2003 through Excel 2010. They should work in 64-bit Windows (in the WOW emulator), as long as Office is installed as 32-bit.
Data Filter Tool
Screenshot:
Features:
The Data Filter Tool add-in does one thing: it filters a table of data and copies or moves matching rows to a new workbook. For example, if you have a list of addresses in Excel, with a column for State, this add-in lets you filter by State and copy (or move) all the rows matching a specific State to a newly created workbook. I guess you could say it's like Advanced Filter, but with a more intuitive interface. Headers are always copied, even if you select the Move option, to preserve headers in the original data. It preserves formatting of the original data (bold, italic, etc) but copies values, not formulas.
- Filters a table of data based on column you specify, copies or moves records to new worksheet
- Does not delete headers, even if you select "Move" option
- Installs itself correctly, no matter how it is opened
- Menu item added to Data » Filter menu
- Reset button clears inputs for data entry of new range
Read my guest post on Mary's Pad about the add-in
Download:
Data Filter Tool Add-In – Excel 2000-2003 version
Data Filter Tool Add-In – Excel 2007 version
*Note: I will not be updating this add-in any further.
Sheet Picker Add-In
Screenshot:
Features:
A simple userform that lets you switch between worksheets. If you have a workbook with many worksheets, it's a pain to switch between them. Sure, there are shortcut keys (Ctrl+PgDn, etc) and the right-click context menu, but this add-in makes it easy to navigate.
Version 2 now includes the ability to switch to any worksheet in any open workbook.
Download:
Sheet Picker Add-In – Excel 2000-2003 version
Sheet Picker Add-In – Excel 2007 version
Sheet Picker Add-In – Excel 2010 version
Shipment Tracking Add-In
Features:
ShipTrack is an add-in UDF that can be used to track packages from FedEx, UPS, Conway and ABF (among others) and return status information directly to the worksheet. Returns current delivery status and (if available) delivery date/time. Now includes CEVA and USPS! Uses XMLHTTP object for lightning-fast web queries! (ShDocvw.InternetExplorer used for ABF; Conway and ABF tracking added by site visitor Mike)
Current version is 4.2.5. This version was completely rewritten in VB6. Supported versions: Excel 2003, Excel 2007, Excel 2010 (32-bit Office only).
Requires MSXML6.dll in your local system32 folder, as well as Internet Explorer and an Internet connection.
Currently supports the following carriers:
- A1 Express
- ABF
- CEVA
- CONWAY
- DHL
- FEDEX
- NEMF
- TNT
- UPS
- USPS
- YRC
- YRC Regional
and more!
Read the original description of the ShipTrack add-in and my announcement of version 4.0.
Download:
To download ShipTrack, visit its website.
Shipment Tracking Userform
Screenshot:
Features:
A companion add-in to the Shipment Tracking Add-In, this add-in provides a userform for batch tracking number processing. This add-in is specifically for batch processing; if you only need to track one or two packages at any given time, just use the ShipTrack add-in described above.
The ShipTrack add-in is required in order to use the userform add-in. You must have it installed before trying to install the ShipTrackUI add-in. Also, it only works for the 2000-2003 version of ShipTrack. Requires msxml6.dll in your system32 folder.
Read my description of the ShipTrack UI add-in.
Download:
Download the ShipTrack Userform add-in for Excel
Random Data Generator Add-In
Screenshot:
Features:
To comply with privacy regulations (HIPAA, Sarbanes-Oxley), organizations that handle sensitive consumer data (names, SSN, DOB, etc) should use fake data when conducting software tests. This Microsoft® Excel add-in allows the end user to generate quantities of fake data for testing purposes, data such as: Gender, Name (First and Last), SSN, DOB, Address, City, State, Zip, Phone.
Version 3.3 of the add-in for Microsoft® Excel 2003-2010 includes new fields to be generated, as well as multiple output formats (txt, csv, mdb, xml and so on) and configurable options.
- Learn more about Random Data Generator
- Purchase Random Data Generator for Microsoft® Excel 2003-2010
- Become an authorized reseller
Amazon Ad Link Generator
Screenshot:
Features:
This add-in is for webmasters and bloggers who use the Amazon Associates program to generate product links for display on their sites. Generate HTML links to any product of your choice, with your affiliate code baked right in!
Current version is 2.1. This version was completely rewritten in VB6. Supported versions: Excel 2003, Excel 2007, Excel 2010 (32-bit only).
Read my description of the addin
Download:
Amazon Ad Link Generator Add-In – Excel 2003-2010
Clean And Trim Cells
Screenshot:
Features:
This add-in for Excel 2003-2010 uses various Excel functions to strip blank spaces from your data. You can use any/all of the following functions:
- CLEAN
- TRIM
- LTRIM
- RTRIM
Current version is 1.0. This version was completely rewritten in VB6. Supported versions: Excel 2003, Excel 2007, Excel 2010 (32-bit Office only). A very simple add-in but I hope you will find it useful.
Download:
Download Excel Cell Trimmer for Excel 2003-2010
Want to Help? Contribute!
These addins have cost me countless hours of work. If you use them, please donate a token of your appreciation. The money you donate means more time creating cool addins and website content, and less time working for "the man".
Find out even more ways you can help out!
