Re: Cross-Project/Sorted To-Do List For Resource

From: John (mjensen_at_theriver.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 10:13:08 -0800

In article <8B7523F1-DED9-4849-8726-CB7E0D9F0D5F@microsoft.com>,
 "GaryGen" <GaryGen@discussions.microsoft.com> wrote:

> I've got multiple projects with a shared Resource Pool. I would like to give
> each person a sorted to-do list with their tasks from all projects.
>
> While I'm open to any way to do this, here are the closest things I've found
> to what I'm looking for:
>
> The "Who Does What" Resource report (or any Resource Report with the
> Schedule option checked) lists all of a resource's tasks. If I could sort
> these tasks by Start Date, this would be great. Selecting which columns are
> displayed after it is sorted would be even better.
>
> Coming at it as a View, the closest thing I can find is the Resource Form
> View. Again, if I could Sort and Select the contents this view, this could be
> a viable option.
>
> Another option would be if there is some way to make the Task-based To-Do
> list go across projects. Currently, they only appear to display the current
> project.
>
> Any help is appreciated. :)

GaryGen,
Because you are dealing with resources and their assignments none of the
sort utilities will work directly. In a report or resource view, sorting
by date will simply sort the resources, not the assignments.

However, with a little VBA you can get what you are after. There are
basically two methods. Within Project VBA can be used in conjunction
with spare fields to set up the parameters for a sort that will respond
to both resources and their assignments. But this method may be a little
limited with respect to formatting the data in the most optimum way. A
second method is to export the information to Excel where it can be
arranged in exactly the format you want.

Another option you might want to look into is the "Multiple Project
Reports" macro posted by fellow MVP Rod Gill. It may or may not provide
what you want. To check it out, go to:
http://www.mvps.org/project/vbacode.htm
and click on the link to Rod's macro.

Hope this helps.
John
Project MVP

Relevant Pages

  • Re: Can I sort resources dropdown in MS Project Gantt Chart
    ... If you sort the resources by Name on the Resource Sheet and choose the ... option to Permanently renumber resources, the lists appearing on the views ...
    (microsoft.public.project)
  • Panic, a strange behavior of lisp program
    ... when SORT is called with a parameter that includes some that ... No actually although CLtL ... this apparent mistake in conversion from CLtL to ANSI-CL. ... Web page that lists all such "obvious" mistakes. ...
    (comp.lang.lisp)
  • SUMMARY: Stop the idiotic questions and useless summaries, please [plus additional resources]
    ... because it includes a substantial number of resources that I find useful ... I recommend avoiding all mailing lists hosted by either Topica or Yahoo ... firewalls: firewalls-subscribe@lists.securityfocus.com ... There are NUMEROUS books on Sun systems admin, ...
    (SunManagers)
  • RE: Incident investigation methodologies
    ... However, what sort of reaction ... Speculation gets you nowhere. ... > malware we encounter. ... > of what makes public lists useful - you can get some ...
    (Incidents)
  • Re: Detailed explanation of how a QuickSort Works
    ... Firstly, if you consider the simple "Bubble Sort" algorithm, it works by running through the entire data set, one item at a time, comparing each item to the previous item and swapping them if they are not already in the correct order. ... by simply running through the entire list just once (and splitting it into two smaller lists) you have cut the sorting time in half. ...
    (microsoft.public.vb.general.discussion)
Loading