Results 1 to 7 of 7

Summary sheet that only publishes rows with entries within a date range

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2021
    Location
    USA
    MS-Off Ver
    Current
    Posts
    8

    Summary sheet that only publishes rows with entries within a date range

    Hello,

    So I am right at the tail end of a workbook I have been working on for a couple days. It's a rolling look ahead task tracking schedule with some auto hide features. The main sheet does everything I need it to (in part thanks to protonLeah). The last feature I would like to have is a slick summary page that only shows rows that have activities scheduled within the next 28 days.

    Once I deploy this workbook the task list may get populated up to hundreds of items, but only a dozen or two will see progress over a 28 day period. Being able to filter out the tasks with no scheduled progress in the next 28 days would really help the crew leaders and foremen communicate and report their short term planning.

    I have attached the full workbook. The "Summary" tab illustrates what I am trying to do automatically. (Note: On the "Calendar" sheet there is a VBA script in the background to handle the 4-week collapse (hide) feature and a couple macros to do/undo that feature. Nothing too fancy or concerning if you worry about activating macros when you open it.)
    Attached Files Attached Files
    Last edited by EnergyFX; 11-06-2021 at 10:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. creating summary sheet for date range
    By EPEisenman in forum Excel General
    Replies: 14
    Last Post: 02-04-2021, 07:10 AM
  2. copy cells and a range of rows to a summary sheet
    By mark-cox in forum Excel General
    Replies: 1
    Last Post: 10-09-2015, 12:20 PM
  3. Automatically add entries to a summary sheet.
    By Michael75 in forum Excel General
    Replies: 1
    Last Post: 07-27-2012, 08:44 PM
  4. Summary sheet from recent entries in other sheets
    By harley87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2010, 11:07 AM
  5. Summary Sheet using date range
    By Huwbob in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-19-2007, 10:21 AM
  6. [SOLVED] Sum Column Entries that fall within Date Range Listed In Rows
    By Ben in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2006, 12:44 PM
  7. Autogenerating entries on summary sheet...help
    By Brian in forum Excel General
    Replies: 3
    Last Post: 03-10-2005, 02:06 PM

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