+ Reply to Thread
Results 1 to 3 of 3

VBA button to run an overdue report

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    6

    VBA button to run an overdue report

    Hi,

    Been awhile since I've need the help of this fabulous forum, but here I am to be a bother again! :-)

    I have worklog that we track ALL our actions in. Most of the actions do not require tracking, but there is one event that does, however. When the information arrives to us we place a future date in column F of the worksheet. For most entries this column is empty.

    Is it possible to insert a macro, with a control button, that would search column F, and if the date is earlier than the current date, then create a new worksheet title "Overdue", and copy that line entry onto the Overdue worksheet?

    I've included a sample of the worklog for you convenience.

    THANKS for any help you give!!!
    Attached Files Attached Files
    Last edited by REFisher14; 10-23-2013 at 12:38 PM.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: VBA button to run an overdue report

    See the attached file (written and tested in Excel 2003). It should work for your
    version of Excel.

    Worksheet "Overdue" is created if it doesn't exist. If it does exist,
    overdue items are appended at the end of the worksheet.

    Alternatively just copy the following Macros into your worksheet.
    You want to run Macro FindOverdueItems().

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-01-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: VBA button to run an overdue report

    Sorry it took so long to get back and thank you!!! (was out of town). Great job, and TYVM!!!!

+ 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. Unique Tickets and Generate Report Button
    By Charoum in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2013, 05:05 AM
  2. Formula to determine total overdue values by length of overdue
    By Midnight_Dragon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 02:03 AM
  3. [SOLVED] VBA to 'on open' of workbook look at all sheets for 'OVERDUE' and transfer to Main Report
    By PippiLaRue in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-07-2013, 08:48 PM
  4. [SOLVED] Macro Help - Command Button to Save Report First
    By Inez15 in forum Excel General
    Replies: 3
    Last Post: 11-28-2012, 09:54 PM
  5. How do I find which report this button links to in access?
    By slay0r in forum Access Tables & Databases
    Replies: 5
    Last Post: 03-28-2012, 11:31 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