Hello All,
I am currently working on a project as a contractor for a company that provides loans to fund different water projects.
The project entailed migrating many loan ledger cards that were originally in lotus 123 database into excel 2013 workbook with many worksheets.
I need to automate the process of designating different payment types automatically by entering one of three values. The values are
Type of Disbursement Code
Loan Fees 1
Interest 2
Initial/Draw_other 3
My current question has to do with the loan fees. Loan fees are incurred at the beginning of the loan and the initial fees are found in C10.
That is copied into M25 under loan fees earned when the initial loan information is put into to the ledger template.
My question is that when there are other terms negotiated with the loan at a later date it is entered in sequence in the extension boxes numbered 1-20.
I would like to activate a sequence of events if there is a date entered into any of the extension boxes starting with I10.
If a date is entered into I10 and a dollar amount entered into I11, I would like it to be reflected in the ledger transaction table.
Is there a formula that would trigger an entry from the extension I10 date being entered and an amount in I11 that would add an entry into the ledger table for that date in the Date column $B25 or first available row keeping in date order.
I would also like the entry to trigger the disbursement code “1” in the Type of Disb. Column $C same row as the date.
And one last thing, I would like it copy the dollar amount from I11 into the Loan Fees earned column $M same row as the other entries.
I appreciate any assistance that you might be able to offer and look forward to hearing any suggestions.
Feel free to take a look at the rest of the formulas and if there is a better way I would love to entertain any improvements that you may suggest.
Thanks,
Deb
Bookmarks