Guidho
Sun Oct 29 04:00:27 CST 2006
I totally agree with John, but what you might consider is to record (or
create) a macro.
Just record the steps you follow to accomplish the correct view, filter,
timescale, ... and store this as a macro. Now assign this macro to a new
button, and you have a single click solution.
Guidho
John wrote:
> In article <A18B77B0-02A6-4A7F-AD35-D927B6F6F41A@microsoft.com>,
> Jesse <Jesse@discussions.microsoft.com> wrote:
>
>> I need to provide some work hours for a project:
>> - total work
>> - actual work
>> - remaining work in 2006
>> - remaining work in 2007
>> I know how to manually go into Resource Usage and grab remaining work for
>> 2006 and 2007. I'm looking for a more efficient and repeatable method. Can I
>> do a custom filter or create a custom field to allocate remaining work into
>> 2006 and 2007?
>
> Jesse,
> I'm not sure what you mean by "more efficient and repeatable", the
> Resource Usage view seems pretty efficient to me if the timescale is set
> for years. You might be able to do it with formulas in custom fields but
> the issue will be with tasks that cross year boundaries - the formulas
> get complex in a hurry - not what I would call an efficient approach. A
> custom filter would be even less convenient and may not even be possible
> or practical with multi-year tasks.
>
> Of course, you could always use VBA, but given that the Usage view can
> already provide the information, why bother.
>
> John
> Project MVP