Is it possible using VBA to automate copying actual hours from onetask to another?

[anovak]

What I want to do is:

1. Within a project
2. Talley ACTUAL HOURS entered BY RESOURCE BY DAY for a GROUP OF
TASKS
3. Overlay the DAILY TOTAL FOR EACH RESOURCE on LINE ONE OF THE
PROJECT

This may sound strange, but there is a legitimate need. Many thanks
for any and all advice concerning this.

Thanks,
Andy Novak
UNT

 

[Rod Gill]

See my post in .project group. Please don't multi-post.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

What I want to do is:

1. Within a project
2. Talley ACTUAL HOURS entered BY RESOURCE BY DAY for a GROUP OF
TASKS
3. Overlay the DAILY TOTAL FOR EACH RESOURCE on LINE ONE OF THE
PROJECT

This may sound strange, but there is a legitimate need. Many thanks
for any and all advice concerning this.

Thanks,
Andy Novak
UNT


__________ Information from ESET Smart Security, version of virus
signature database 4849 (20100208) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4849 (20100208) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[James Fraser]

1. Within a project
2. Talley ACTUAL HOURS entered BY RESOURCE BY DAY for a GROUP OF
TASKS
3. Overlay the DAILY TOTAL FOR EACH RESOURCE on LINE ONE OF THE
PROJECT

I'm not sure what you mean with the third. In particular, what do you
mean by "Overlay?" Maybe set a custom field value? but then you would
need one field for every resource?

I've done the first two parts frequently in SQL and it wouldn't be
difficult to do in VBA.


James Fraser

 

[anovak]

I'm not sure what you mean with the third. In particular, what do you
mean by "Overlay?" Maybe set a custom field value? but then you would
need one field for every resource?

I've done the first two parts frequently in SQL and it wouldn't be
difficult to do in VBA.

James Fraser

James,
We are emulating Administrative projects by creating categories of
work in Task lines and assigning all team members at 0%. Each
category/task line starts out as a milestone (0 hours) and then as
folks post actual hours the milestone turns into a bar which gets
longer as more time is posted.

Problem is some managers go crazy with the amount of granularity (the
number of categories) they create. So, after the fact I want to add
up all posts for a resource by day and replace the empty "bucket" in
the catch-all line 1 category with whatever the total was for all the
details, then delete the detailed tasks. In essence, I want to rollup
the time entered by day into all the granular categories into a
broader category.
Hope this makes sense.
Andy