+ Reply to Thread
Results 1 to 2 of 2

Entering date triggers subsequent entries automatically

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2013
    Posts
    1

    Entering date triggers subsequent entries automatically

    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

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Entering date triggers subsequent entries automatically

    Hi Deb

    Welcome to the Forum!!!

    Will there be ONLY Loan Fees entered into the Extension Boxes?

    Is that detritus in Row 806 and Rows 1005 to 1685 serving any purpose?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-13-2014, 09:50 PM
  2. Date Triggers
    By trainer102 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2014, 07:48 AM
  3. macro for entering formula and subsequent pasting of blank column
    By ElisaB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2011, 11:21 AM
  4. Automatically entering date into cell
    By CJ944 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2010, 04:16 AM
  5. Automatically entering today's date when saved.
    By SplatterKat in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-20-2006, 11:46 AM
  6. Entering the date before Automatically
    By thejuni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2006, 09:30 PM
  7. [SOLVED] Tool fro entering data in subsequent cells
    By Pierre in forum Excel General
    Replies: 2
    Last Post: 08-24-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1