Need to index tasks to verify if they are open/in progress or closed?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gojners
    New Member
    • Mar 2008
    • 1

    Need to index tasks to verify if they are open/in progress or closed?

    I need to go through a set of tasks. Each task has a priority (low/medium/high) and a status (Open/In progress/Closed). Each task also has a membership (Internal/External/Other).

    My problem is that I need to (in pseudocode):
    1 Go through all tasks to see if they are "Open" OR "In progress"
    2 For all tasks that are "Open" OR "In progress" --> Order the tasks based on priority (High = first row of the column. Low = rows below both High & Medium)
    3 Pick the top three tasks for each membership (Internal/External/Other)

    The end goal is to let the macro traverse through a sheet with rows = tasks with columns for number/priority/task/membership/status/date etc. and pick out the top 3 most prioritized task per membership (internal/external/other).

    Can anyone crack this nut for me?

    Thanks!

    P.S. I'm quite new to VB so please go easy on me and explain the code suggestions =)

    Isabella
Working...