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
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