+ Reply to Thread
Results 1 to 1 of 1

Macro required to generate recurring list using frequency and calendar inputs

  1. #1
    Registered User
    Join Date
    Dublin, Ireland
    MS-Off Ver
    Excel 2010

    Exclamation Macro required to generate recurring list using frequency and calendar inputs


    I am an absolute newbie to Macros and have no experience, so forgive my ignorance but I would really appreciate any help that can be offered.

    I have a list of tasks that have a field for frequency which can be daily, weekly, monthly, quarterly, half yearly or yearly. I also have another field with more information on the frequency, such as which day the monthly task takes place, or which month the quarterly task takes place...

    For a basic example:
    Task: Frequency: Frequency Info:
    Print Report Daily N/A
    Send status Weekly Friday
    Update Issues Weekly Monday
    Update estimate Monthly Last Thursday
    Report Costs Quarterly Jan, Apr, Jul, Oct

    What I am trying to do is build out a list that each month calculates exactly how many tasks should be completed. So I want to give it a parameter entry as a month and a year, say May 2011, and then generate all the tasks for that month. So using the example above, if there are 22 working days (working week in May began 2nd and finishes 31st) then I should have
    - 22 recurring daily Report tasks
    - 4 recurring Send Status weekly tasks (given there were 4 fridays in May)
    - 5 recurring Update Issues tasks as there are 5 Mondays in May
    - 1 Update Estimate monthly task
    - no Report Costs quarterly task as its not expected in May.

    Is this possible? Is it too complex to create? Any help, pointers are really really appreciated...
    Last edited by rowlandrat; 05-10-2011 at 05:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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