Four Excel add-ins are now available!

First, I give you …

1) Data Filter Tool!

    The Data Filter Tool 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.

Screenshot:

Features:

• 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
• “Help As You Go” feature allows you to get help immediately by clicking on the text labels on the form

    Read my guest post on Mary’s Pad about the add-in

    Download Data Filter Tool

---

2) Sheet Picker Add-In

    My second add-in is 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.

    Read my description of the Sheet Picker add-in

    Download the Sheet Picker add-in for Excel

---

3) Shipment Tracking Add-In

    An add-in UDF that can be used to track packages from DHL, FedEx and UPS and return status information directly to the worksheet. Uses XMLHTTP object (not ShDocvw.InternetExplorer) for lightning-fast web queries!

    Read my description of the ShipTrack add-in

    Download the ShipTrack add-in for Excel

Requires MSXML 6.0 as follows: c:\windows\system32\msxml6.dll

---

4) Shipment Tracking Userform

    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.

    Read my description of the ShipTrack UI add-in

    Download the ShipTrack Userform add-in for Excel

Requires MSXML 6.0 as follows: c:\windows\system32\msxml6.dll

Created On: July 19, 2008 – 7:39 am