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.

shop_direct.xlsm | |
File Size: | 38 kb |
File Type: | xlsm |
Found this on the web just before I sat down to write one myself!

Rename files.xls | |
File Size: | 98 kb |
File Type: | xls |
A collection of useful functions and procedures (last update Nov 2010).

mikesvbadrawingboard_v1.xls | |
File Size: | 184 kb |
File Type: | xls |
Splits an Excel spreadsheet into sperate sheets for groups of data. Even copies headers!
To install
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.

Sheet splitter.xla | |
File Size: | 43 kb |
File Type: | xla |
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.

Manual vlookup.xls | |
File Size: | 118 kb |
File Type: | xls |
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.

Excel 97 toolbar.xls | |
File Size: | 161 kb |
File Type: | xls |
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.

sudoku solver.xls | |
File Size: | 212 kb |
File Type: | xls |
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)

speller plus.xls | |
File Size: | 175 kb |
File Type: | xls |
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)

bell chimer.zip | |
File Size: | 4756 kb |
File Type: | zip |
10 - "Freestuff" checker
Autochecks a popular freestuff websites for a wish list

Checker.xlsm | |
File Size: | 268 kb |
File Type: | xlsm |
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

convert_from_xls_to_xlsm.xlsm | |
File Size: | 12 kb |
File Type: | xlsm |
13 - Mortgage calculator - what can you afford to buy?

mortgage_-_what_can_you_afford.xlsx | |
File Size: | 22 kb |
File Type: | xlsx |
14 - RAG (red / amber / green) topic tracking tool (PowerPoint)

rag.pptm | |
File Size: | 254 kb |
File Type: | pptm |
15 - BlackBerry SMS csv file merging tool

bb_sms_file_sorter.xlsm | |
File Size: | 25 kb |
File Type: | xlsm |
16 - Email follow up

email_reminders.txt | |
File Size: | 5 kb |
File Type: | txt |