Autofill in Excel is a useful feature that allows us to avoid repeated entry of the same formula. We can either click and drag to perform the same calculations if we have small amounts of data or double-click on the autofill handle if we have thousands of rows of data. Wouldn't it be interesting to have a macro that automates the process of autofill? We describe in this video how to use Autofill using Excel VBA or via a macro.
