I get data from title companies in Excel format to send direct mail to new clients. There are certain rows with loan amounts and certain rows where new interest rates would fall under. I want to create a macro to go row by row and calculate new payment amount in 30 year fixed rate loans. My data sheets have 3,000 plus counts of individuals with an existing loan to refinance. This spreadsheet will then be paired to a mail merge in Word documents. I know the formulation from your video on Youtube called How to make a Fixed Rate Loan/Mortgage Calculator in Excel from 2008. I think it is great that a video from so long ago is still very useful today. Thank you for your knowledge.