Excel File Picker VBA

• June 3, 2020
• Marcus Small

Choosing a file with as an Excel file picker can be useful if you want to be able to pick a specific file to edit in a VBA procedure.

Telling a Story with an Excel Dashboard

• December 30, 2019
• Marcus Small

Inspiring Excel dashboards that are functional and tell a compelling story.

Sales Excel Dashboard

• June 15, 2019
• Marcus Small

An Excel sales dashboard which focuses on quarter and YTD data. It has a slicer and spins on a monthly combo box.

Excel Timesheet Example

• May 9, 2019
• Marcus Small

Creating an excel time sheet is easier with a template to start with. This blog post provides the template and the instructions for using it. Excel, Timesheet, template.

Protect a Worksheet, Use the Autofilter

• October 19, 2018
• Marcus Small

Protect an Excel worksheet and use the auto filter.  A how to guide.

Excel Copying Variable Columns with Array

• June 4, 2016
• Marcus Small

My tassie friend Valario asked another interesting and engaging question.  The question came from the blog post ‘Read Individual Columns to An Array’.  The design of the code was a little bit static so Valerio’s question was as follows.

Another question just to ruin your night!

Scandinavian Infograpic in Excel

• May 30, 2016
• Marcus Small

The above infographic is one of my favourites of the Nordic region. It is very simple and yet tells a story about 4 countries in Scandinavia. The Excel infographic has the top 5 companies for each country (Iceland is excluded due to its small size - sorry). It has data on career and staffing data. There is some population metrics, GDP and GDP Growth which is low all around the world as a result of the global downturn after 2008. Let's hope that ends soon.

Excel Merge Sheets to Master

• February 23, 2015
• Marcus Small

This article draws on the post from the site which is dedicated to merging worksheets in a workbook into a single master sheet Consolidate Sheets.  This technique can be significantly simplified with a VBA macro.   I have posted this type of reply on forums dozens of times.  Howeve this reply differs just slightly.  The following will consolidate data so the data tables appear side by side in the consolidaiton tab.  So if Sheet 1 appears:

Starting a Blog

• January 4, 2015
• Marcus Small

I have been toying with the idea of a blog for some time now.  Fact is my website is too large and the menus have too many items so on most screens the material drops off the page.  I am limited as my choice of website builder does not offer scrolling drop down menus.  It might be for the best as having 50 or more items under one menu is less than ideal.