Results 1 to 15 of 15

Finding Delinquent Accounts from Excel Database and Posting them to a Separate Sheet

Threaded View

  1. #1
    Valued Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    358

    Finding Delinquent Accounts from Excel Database and Posting them to a Separate Sheet

    Date Sort Test-New.xlsm

    Ok so here is a puzzle for a VBA Guru.. I have no idea how to proceed.. All I have done so far is create a command button that creates a new sheet called status when its clicked. In the Database1 Sheet there are accounts constantly being added and deleted, each row in Database1 is 1 account. I need a VBA Macro that can scan the Database1 sheet and locate any accounts that are delinquent and post some specific info from those accounts on the new status sheet.
    In the Database, "Column I" shows the beginning date of each account. Payments are due on a monthly basis and the exact due day is specified in "Column L". The attached sheet shows some fictitious accounts and i manually populated the status sheet to try and show what I need the status sheet to show from the delinquent accounts. Please post any questions and I will try to answer them as best i can to clarify what is needed. Any help is greatly appreciated!
    Attached Files Attached Files
    Last edited by unit285; 02-03-2016 at 02:18 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automate Posting Jounal entries to Ledger Accounts
    By Rich in Naples in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2015, 05:09 PM
  2. How to keep record of invoices printed in separate database sheet (Please Help)
    By zaidbinsaleem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2014, 02:51 AM
  3. Replies: 2
    Last Post: 12-27-2013, 09:24 AM
  4. Replies: 7
    Last Post: 04-14-2013, 12:28 PM
  5. finding cellson 1 sheet and posting in another
    By Duckie in forum Excel General
    Replies: 1
    Last Post: 01-27-2013, 09:31 PM
  6. I Want to store my invoice sheet in a separate sheet as backup database
    By Apurav in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-19-2012, 01:31 PM
  7. Finding accounts credited more than once by the same person
    By bmunoz64 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-15-2009, 08:53 AM

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