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

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:

Tags Excel, Dashboard, Design

Excel Show Missing Sheet Tabs

Tags excel, missing, tabs, sheets

Run Macro Overnight Automatically

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

Creating an Excel Dashboard - A Guide with Templates

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