1 - A quick fix for formatting Sunny's shop direct orders
NB. If file downloads as zip file just rename to "xlsm" before trying got open.
Found this on the web just before I sat down to write one myself!
A collection of useful functions and procedures (last update Nov 2010).
Splits an Excel spreadsheet into sperate sheets for groups of data. Even copies headers!
Excel 97-03: Save to your computer and click tools>Add-Ins>Browse>Click 'yes'
Excel 2007: Click the circle>ExcelOptions>Add-ins>Manage Excel Add-Ins>Browse>Click 'yes'
To use: open you spreadsheet and use "control+R" to run.
Works like a vlookup but without the formula. Use this when your spreadsheet is
dying under the weight of vlookup statements. The results are non-dynamic.
A toolbar especially designed for MI analysts who regually manipulate and analyse
large amounts of data. Includes delete duplicate, transpose, remove '#N/A' and other
special formating tools all at the touch of a button.
Spreadsheet based solver, uses multiple logic algorithms to offer hints and solutions to
the Japanese Sudoku puzzle. All hints and solutions are based purely on logical
conclusions with no guesses or assumptions.
8 - Speller Plus
A spelling practice program based on a spreadsheet. Has lots of options to test in
groups or worst spelt words. Not error trapped as I wrote this for personal use. First
version Feb '09 (last update Apr '09)
9 - Bell Chime
Written while teaching English in South Korea. The school I was working in didn't have
a bell system but each class room has a PC with speakers. This allows up to 8 alarms
to be set to ring indicatin the start and end of each class. There are resident sounds
but also sounds can be imported. First Version Jan'08 (last update June '09)
10 - "Freestuff" checker
Autochecks a popular freestuff websites for a wish list
11 - Speed and Efficiency Tips
What a difference a few calculations make!
Application.Calculation = xlCalculationManual
Application.Calculation = xlCalculationAutomatic
(Thanks Kevin Roper! - Mike's local copy)
12 - Batch convert from .xls to .xlsm
13 - Mortgage calculator - what can you afford to buy?
14 - RAG (red / amber / green) topic tracking tool (PowerPoint)
15 - BlackBerry SMS csv file merging tool
16 - Email follow up