Results 1 to 9 of 9

Thread: Due activity list including next 5 days

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte Rahul Malhotra's Avatar
    Join Date
    Apr 2018
    Posts
    43
    Articles
    0
    Excel Version
    2013, 2016

    Due activity list including next 5 days

    Dear Experts,

    I am trying to use the VBA for getting a filtered list of due activities based on due dates for the next approaching 5 days includes today but could not able to do so and with using the current script I am able to get only todays due activities and not for next 5 approaching days. I am not sure where is the disconnect. Request to you please do help me on the same.

    Code:
    Sub due()
    Application.ScreenUpdating = False
    With Sheets("Expected Output")
        .[A3].CurrentRegion.Offset(1).Clear
        .[Z1:Z4].Value = Application.Transpose(Array("Due Date", "Daily", "As Needed", "As Received"))
        .[Z5:Z10].Value = Evaluate("TEXT(TODAY()+ROW(1:6)-1,""dd.mm.yyyy"")")
        Sheets("Details").[A3].CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=.[Z1:Z10], CopyToRange:=.[A3:G3]
        .[Z1:Z10].Clear
    End With
    Application.ScreenUpdating = True
    End Sub
    Attached Files Attached Files
    Last edited by p45cal; 2021-10-14 at 05:24 PM. Reason: removed highlighting tags from code

Posting Permissions

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