Essential Excel Add-In

Essential Excel Add-In is a Microsoft Excel Add-In (xla file), written in VBA, that contains useful User Defined Functions (UDFs) and macros to performs a number of different tasks that either Excel does not provide.

The Essential Excel Add-In project is hosted on SourceForge:

• Project Summary Page (project forum, bug reports, feature requests, stastics, etc.)

Duplicates Remover

The Duplicates Remover macro finds duplicate entries within a column and copies the duplicate items to another Worksheet. This macro is useful when trying to filter on only unique items. All rows with unique entries and the first row of any duplicate will be copied to a 'unique' Worksheet. Any rows containing duplicate entries will copied to a 'duplicates' Worksheet.

Find and Copy

The Find Matches macro copies rows from one worksheet to new worksheet if the row contains a specific piece of text. There is also an option to always copy the first row.

Text Case Changer

This macro performs a couple of functions. It can change the case of a selection (to upper or lower case). It can also remove calculcations and formats and perform a search and replace based on a text files data.

Spreadsheet Shader

This macro colours alternating lines in a Worksheet selection to aid the user reading the data when it is printed out.

Other Controls

Other bits and pieces that make life easier.

Find Matches

The Find Matches macro highlights matching cells between two ranges

Sync Scrolling

Makes synchronised scrolling simpler by applying a consistent zoom, synchronising from the top of the window and showing windows side by side.

User Defined Functions (UDFs)

These are User Defined Functions that can be called within a cell much like =left(A1,2) etc.

StringFormat

This performs the function 'Format' that is available within VBA. I use this to change the format of numbers to a fixed width i.e. 1 to 001, 47 to 047 by using the following in a cell:

=StringFormat(A1, "000")

SameValue

RegEx

RegExTest

RegExReplace

Downloads: