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.)
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.
This macro colours alternating lines in a Worksheet selection to aid the user reading the data when it is printed out.
Other bits and pieces that make life easier.
The Find Matches macro highlights matching cells between two ranges
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.
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:
|Click to download the latest version from SourceForge||N/A||N/A||N/A|