Conditional formatting is useful for highlighting cells or ranges if a condition is true. For example: highlighting negative values as red or positive ones as green. You can also do more complex formatting like highlighting an entire row if it meets ...
Download template This mortgage calculator will allow you to accomplish three different things: 1) Determine the housing price based on a desired monthly payment, interest rate, and terms. 2) Determine the monthly payment based on the price of a ho ...
In a previous post I covered my amortization/depreciation template.Here I will cover how to do present value and future value calculations that are used in that template. I will start with a savings example. Suppose I want to accumulate $500,000 in s ...
I have saved this sample file here if you would like to look at the data set and have a closer look at how the formulas work.In this post I will cover some simple summation formulas and when best to use them. I have a sample data set that has stores, ...
Download Template This template allows you to track multiple amortization / depreciation schedules and summarize them all in one tab. Above is a completed schedule with the inputs (highlighted in grey at the top) filled in. As you can see ...
Download Template This is an updated version of a prior post that generated a statement without VBA, but the limitation there was you had to save the pdf yourself. This updated version allows you to do the following: - Save the current statement ...
Download Template In this template you can generate a chart showing the history of a customer's aged accounts receivable. This chart will show a breakdown by invoice age so it will be able to tell you a great deal in one picture: the customer's tota ...
In many cases it is inefficient to run one long sub procedure in VBA. Rather, it is easier to break them up into smaller processes. I'm going to show an example of how to do this using a simple square root function, and having a variable passed fr ...
Doing loops in VBA is very useful because it allows you to go through a range of cells, evaluate each, and then take an action if a specified criteria is met. I am going to go through a couple of examples to show you how you could do this to highligh ...
Counting blank and non-blank cells is fairly straightforward, but what about the cells that have formulas in them that don't return a result and look blank? They can distort those calculations. In this post, I'll cover how to count the number of cel ...
