I have an amortization scheduled worksheet; I need to additional calculate the interest paid based on the date of payment. Some payment maybe made early or late, I need to calculate the interest paid based on the date and add it to the running balance. Can someone help? My spreadsheet is attached. Tester.xlsx
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.