Multiple Loans

[Viking08]

Has anyone built a spreadsheet what allows you to amoritize multiple loans?

I have a spreadsheet with 38,000 loans and all their respective information. What I want to do is have a macro that will calculate the amorization for each loan indivdually and then paste the formula results, as values, in one row and then pull in the next loan and paste the results below the prior results.

Can this be done with a macro?

Ken

 

[brettdj]

Probably - if the loan info is laid out in a repeated, or least predictable pattern

- can you provide an example?


Dave

 

[Viking08]

Dave,

How can I attach a file to the forum?