Excel User Group

Template macros enabled.xlsm

Matthew Geary — Tue, 14 May 2013 15:40:18 GMT

Nothing Here

Jim Cone — Sun, 24 Oct 2010 10:44:39 GMT

Matching Game

Techronology — Tue, 15 Jun 2010 19:37:17 GMT

<a href="http://www.techronology.com/index.php?pageID=006002&prodID=game001">http://www.techronology.com/index.php?pageID=006002&prodID=game001</a>

Matching Game (WingDing Match)

Can you believe I did the original version during my downtime at work. Shame on me, but I was really surprised it work; and now, I know you can create graphical spreadsheet games without using forms.

Description:

Wingding Match is a dynamic matching game similar to Concentration with a twist.

You see, if you miss two consecutive attempts then the remaining character positions are automatically scrambled. After a level is scrambled, completing the board becomes more difficult.

Three levels comprise the game and your goal is to find matches or make guesses hoping to find matches. More matches are required as you complete each stage, which also increases the level of difficulty.

Enjoy!!!

Dynamic Yearly Calendar

Techronology — Fri, 11 Jun 2010 20:35:43 GMT

http://www.techronology.com/index.php?pageID=004002&prodID=tool001

Change years from a single click. The dynamic aspect of this tool allows you to populate an entire year instantly.

In addition, the main control and selection tools are separate from the calendar itself, enabling you to print only the calendar.

This tool allows you to select years from 1900 to 2400.

Guess what!? No macros were used in this development.

World Cup 2010 Fantasy Football League

Nick Hodge — Thu, 10 Jun 2010 22:42:28 GMT

A macro-enabled 2007/10 workbook (xlsm) with the matches from the 2010 World Cup in South Africa. Full instructions on the opening sheet. Add participants and predict scores which will automatically update the participants and the actual teams tables

Have fun and Come on England!

Blank Workbook

Jim Cone — Thu, 29 Apr 2010 17:41:14 GMT

Blank Workbook

Jim Cone — Thu, 10 Dec 2009 03:41:56 GMT

Nothing Here

Jim Cone — Fri, 02 Oct 2009 22:07:19 GMT

Nothing to Download

Jim Cone — Sun, 07 Jun 2009 22:49:00 GMT

Sorry nothing worth downloading here.

Direct Data Table Add-In 2003

kaak — Tue, 02 Jun 2009 06:55:36 GMT

This add-in adds a group to the data-menu for creating pivottables and querytables after entering a servername, database and sql statement.

Direct Data Table Add-In

kaak — Tue, 12 May 2009 12:23:14 GMT

This add-in adds a group to the data-tab for creating pivottables and querytables after entering a servername, database and sql statement.

Using form option buttons & conditional formats to highlight columns

Rick Williams — Wed, 06 May 2009 23:36:52 GMT

A sample file that demonstrates how to use option buttons & conditional formats to highlight columns in a worksheet.

Blank Workbook

Jim Cone — Sun, 07 Dec 2008 20:01:08 GMT

Working with duplicates in Excel 2007

Nick Hodge — Tue, 08 Jul 2008 22:08:30 GMT

This is just a short video showing how easily Excel 2007 deals with duplicate data. A task that whilst not tricky in earlier versions, was certainly more time consuming!

If this is received well, I may do a few more 'shorts'

Make long string data entry easier

PeterG — Wed, 25 Jun 2008 07:48:37 GMT

This addin is designed to facilitate the handling and viewing of long text strings in either cell values or cell notes.

It also makes it easier to edit complex formulas.

Using Worksheet Parameters On External Data (Video)

Nick Hodge — Fri, 16 May 2008 22:13:45 GMT

This file shows data being brought in from an Access database, into Excel 2007, using MS Query (ODBC) and parameters that are based in cells on the worksheet and update the query by changing these.

Sample VLookup Solution for Mercury Renovations

David Badilotti — Mon, 10 Mar 2008 13:16:37 GMT

This file was created to demonstrate a way to consolidate multiple inventory tables into a single table on which a VLookup can be performed.

Fast Filter

Roger Govier — Mon, 10 Mar 2008 12:32:25 GMT

With FastFilter, you can type criteria in the row above an AutoFilter, instead of selecting from the

dropdown lists. The cells with criteria change colour, so you can easily see which columns have a filter applied,

and see what the criteria are. You can filter one or more of the columns.
This ZIP file replaces the previous loaded xls file.

Working with Pivot Tables (Part 1)

Nick Hodge — Fri, 15 Feb 2008 21:33:33 GMT

This is the first of a series of pivot table videos, showing how to build and manipulate them using external data. Specifically an Access Database.

It is also a trial for me to see how it works and how popular they are. In this first one, I apologise for the typewriter-like keyboard presses. I have a laptop with internal microphone.

Hope you enjoy this and I'll try and get around to a few more, on this subject and others.

DataPig Access Compact and Repair Utility

Mike Alexander — Mon, 28 Jan 2008 15:48:32 GMT

- Perform compact and repair on all your Access .mdb and .accdb files at once
- Create an index of all Tables and Fields in every Access database on your system
- Create an index of all Queries in every Access database on your system
(For MS Access 2002,2003, 2007)

Write worksheet comments to text file

Nick Hodge — Thu, 24 Jan 2008 22:44:35 GMT

This file uses the VBA output routines to take comments in a workbook and write them out to a text file. It appends in the text file the sheet and address from whence they came. There is also a routine to copy comments in one sheet to the same cells in another.

RefTreeAnalyser: Formula Auditing to the Max

Jan Karel Pieterse — Thu, 24 Jan 2008 12:46:35 GMT

RefTreeAnalyser For Excel

Excel formula auditing taken to the next level!

Why RefTreeAnalyser?

Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

DataPig Excel Explosion

Mike Alexander — Tue, 15 Jan 2008 21:38:17 GMT

This Utility will split your Excel dataset into separate Excel workbooks or separate tabs based on criteria you define! So you can create a separate workbook for each Employee in your dataset or each City, or State...etc. All this with one click! (For MS Excel 97,2000,2002,2003,2007)

Build a worksheet index with hyperlinks

Nick Hodge — Tue, 15 Jan 2008 21:23:00 GMT

This workbook has a sheet of each type available in Excel. if you click on the 'Create Index' button, it adds a worksheet with the worksheet name, type and, if possible, a hyperlink to that sheet. It just a file by way of VBA demo. (Alt+F11 to look at code)

DataPig Access Explosion

Mike Alexander — Tue, 15 Jan 2008 04:01:09 GMT

This Utility will split your Access datasets into separate Access Tables, separate Excel workbooks or separate Excel tabs based on criteria you define! So you can create a separate workbook for each Employee in your Access tables or each City, or State...etc.