Excel Autofill - Fill Down to Bottom of Range

In Excel you may wish to drill down on a range which has a header value not already contained in the rows. The following article shows a practical example of how to generate a unique row name based on the heading in a specific place. The procedure is in VBA.

Tags Excel, VBA, Drill down, Fill down, filldown, autofilter

Social Media Dashboard in Excel

This is a social media dashboard created in Excel. It is free to download and has all of the graphs and source formula in the file.

Tags Excel, Dashboard, Social media

Range Areas in Excel with VBA

Trap a range area with VBA and loop to next range area. This little used Excel VBA technique is awesome and a real win when you learn the mechanics of it.

Tags Excel, Range, Area, Loop

Construction Industry Infographic

This is an Excel infographic covering he construction industry. It displays revenue and expenses with some relevant pictures and charts. You should be able to modify it to your industry.

Tags Excel, indographic, construction, Revenue, Expense, Asset

More Dashboard Updates

This is a post about updates to the Excel Dashboard section of the smallman site.

Tags Excel, Dashboard, Reports

Find Closest Match in Excel

Find the closest match in a range of cells and highlight that match.

Delete Blank and Zero Value Cells from Columns

Remove blank or zero values from a range of cells in one swift movement with the help of Excel VBA.

Make Excel Speak

Make Excel talk or speak words from text in a cell. Use Excel's voice commands to have a bit of fun with your friends.

Excel - Too Many Different Cell Formats

Excel too many different cell formats - this VBA solution will fix the problem.

Project Modelling in Excel

An Excel model which focuses on a wind farm in Brisbane.

Excel Looping Through Sheet Code Names

This is an Excel VBA procedure to loop through worksheets using the worksheet code name.

Select First Item in a List Box Automatically with VBA

CPA Australia's Management Accounting Conference

Presenting at the Management Accounting Conference 2017.

Full and Part Summaries with the Dictionary

Creating summaries using the Excel VBA scripting dictionary is something you will want to learn. The dictionary is powerful and can summarise data very quickly. This blog post takes you through the process of using the Excel Scripting Dictionary.

Tags Excel, scripting dictionary, Sum, Multiple, Columns

12 Month Rolling Chart

A 12 month rolling chart in Excel which will update both forwards and backwards dynamically on a chart.

Life on the Road

This years travel has finally commenced. It has been a long time since I hit the road in any real way late last year from memory but once it starts it is the gift that keeps on giving.

Conditional Formatting with Format Cell

The article shows how to format an Excel cell with different colours through the format cell feature in Excel.

Tags Excel, Format, Cells, Font

Excel Dashboards Essential Updates

This Excel dashboard displays revenue and expense metrics with some additional KPI data.

Tags Excel, Dashboard, Update

Compare Two Lists on Different Sheets and Output Matches

Compare two lists with the Excel VBA scriting dictionary. Output the results of the matching cells to a third sheet.

Tags Excel, Compare, two Lists

Copy/Paste Top n Visible Rows

I recently had a question regarding copying data after a filter had been applied. What if we wanted the top n items from a list to be copied to another place. The problem to address here is that a filtered list can have cells which are hundreds or thousands of rows apart.

< Newer Posts Older Posts >