I make a lot of amortization tables for prepayments and unearned revenues every month. I calculate the amortization on a daily basis and alloctae the proper amount for each month at the end of the month.

I’m new to VBA and wanted to ask if there is a way to fully automate the process of making such tables. the variables I need to include are simply starting/ending dates and the amounts. other inpus are fixed.