Populating an Excel Table from a Range of Cells with VBA

Working with Excel ranges and adding information to the associated datasets is relatively straight forward. When it comes to adding data to the bottom of a table you can do so with VBA.

Fuzzy Distribution with Randbetween

Apply fuzzy logic to produce randomized list of data.

Add Minimum and Maximum for Chart in Cells

When utilizing charts in Excel, it is frequently beneficial to manage the axis scale—particularly the minimum and maximum values—to enhance clarity or highlight significant data trends.

Tags Excel, Charts, Minimum, Maximum

Inflation Over Multiple Years in a Single Cell

A financial model often estimates the financial results for a single company within the broader economy, focussing on microeconomic difficulties. This article outlines how to add inflation over multiple periods in a single cell.

Tags Excel, Escalation, CPI, Increase over time

Hubspot Dashboard

A dynamic dashboard based on Hubspot data. This is a dashboard that has been designed to summarise hubspot data in a small space and tell a compelling story with the data.

Tags Dashboard, Excel, Data

Monthly Dashboard With Supporting Metrics

A guide to dashboard design. Outlining several crucial phases that are involved in creating an Excel dashboard: Specify your audience and purpose, Collect Inforation, Select KPIs, generate caclulations, Design, Test etc.

Tags Excel, Dashboard, Design

Excel Show Missing Sheet Tabs

Excel's default setting is to show all the tabs below the workspace. In this article you will see how tabs can be made visible when you are unable to see them.

Tags excel, missing, tabs, sheets

Run Macro Overnight Automatically

unning a macro automatically is possible. The first thing to say about this procedure is you need to keep Excel running on your machine when you leave the office. Incidentally this procedure can be run at any time of the day or night.

Tags Excel, Macro, Run Automatically

Split File into Parts and Save to Directory

In this article we will split a file into many different subsets and save each subset to the directory of your choice.

Tags split file, Excel, VBA

Most Popular Author

Eloquens have released a list of their most popular authors for 2023. I was blest to win the award this year.

Creating an Excel Dashboard - A Guide with Templates

Dashboards are the modern day way to display informative meaningful data. They show key information in a defined space. The rules and process behind making key performance dashboard will be covered in this article.

Tags Excel, Dashboard, How to Guide

Real Estate Excel Dashboard

An Excel dashboard that displays USA real estate data USA.

Tags Excel, Dashboard, Heatmap, Real estate

Updating Excel Dashboards

An updated Excel dashboard created entirely in Power Pivot.

TheSmallman in Another Top Blog Rank

An Excel blog ranking website that has TheSmallman included in a distinguished list of Excel VBA blogs.

Project Tracking Dashboard

Project tracking dashboards are a great way to monitor the progress of a project over time. This is an example of a well laid out dashboard with a number of key operational metrics.

Tags Project, Dashboard, Excel

Excel Unique Formula

The UNIQUE formula has really changed the game in Excel as a way to interrogate a list and return all of the unique items in that list.

Tags Excel, Unique, Sort

Horizontal Range to Vertical Range in Excel

With the advent of Power Pivot the task of flipping data is made very simple. The Unpivot Other Columns command is a bit of a game changer. It easily moves data from horizontal to the more database friendly vertical range very nicely.

Tags Excel, VBA, Transpose, Horizontal to Vertical

Hiding Rows Quickly with VBA

Hiding rows with Excel VBA the simple way using a union range. Typically if you want to hide rows very fast with VBA the autofilter is the tool of choice, in a single line with one swift move thousands of rows can be hidden. Amazing.

Tags Hide rows, Union Range, Fast, VBA

Cascading Combo Boxes 3 and 4 Layer

Create 3 and 4 level dynamic lists into an Excel data validation on the fly by managing a vertical list with no named ranges. This is the data validation list management tool you have been looking for.

Tags Data Validation, Cascading Lists, Excel, VBA