Essential
Excel Add-In
Essential
Excel Add-In is
a Microsoft Excel Add-In, 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.
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.
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")
