I am trying to add code to my macro that will calculate interest on a mortgage. For example, in spreadsheet 1, i have 30 rows of data (each a different loan) that i need to calculate interest. I need the macro to calculate the interest for each of the 30 rows of data. Once calculated, i will use the sum function to add up the interest for all the loans in spreadsheet 2. Can anyone help me out?