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.)
Download Essential Excell Add-In
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.
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
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
