F
Fondly9999
I wish to show a column for each specific resource assigned to the project
and the data should be work per task placed in each row.
and the data should be work per task placed in each row.
J
Joe
Use Resource Usage view. That will give you what you are looking for.
F
Fondly9999
No, that only shows each recource with a tasks assigned in a list below.
Column 1 should be project tasks, Column 2 and up would show each resource by
name. The data in the table would be work as assigned to each resource.
Column 1 should be project tasks, Column 2 and up would show each resource by
name. The data in the table would be work as assigned to each resource.
J
Jan De Messemaeker
Hi,
What you are looking after doesn't exist in Project out of the box.
What you are looking after doesn't exist in Project out of the box.
F
fondly9999
I understand that may mean setting up a custom column using a formula. Any
ideas on how that may be done?
ideas on how that may be done?
B
Brian K - Project MVP
Jan said:
Maybe Im misreading the request but the last reply sounds a lot like
the Task Usage View. Am I missing something?
J
Jan De Messemaeker
Hi Brian,
Yes, that was already suggested and rejected by the poster.
He wants a two-dimensional tablme with tasks as onbe dimension and resources
as the other (so time is not a dimension whereas in Project it always is).
It can be done by a VBA procedure filling an Excel sheet.
Greetings,
Yes, that was already suggested and rejected by the poster.
He wants a two-dimensional tablme with tasks as onbe dimension and resources
as the other (so time is not a dimension whereas in Project it always is).
It can be done by a VBA procedure filling an Excel sheet.
Greetings,
J
Jan De Messemaeker
Hi,
No, I meant using VBA to copy the relevant data into Excel which has the
kind of two-dimensional tables you request. The Project objects part of such
a procedure is pretty straightforward but locating the right cell in Excel
makes it a bit longer to write.
HTH
No, I meant using VBA to copy the relevant data into Excel which has the
kind of two-dimensional tables you request. The Project objects part of such
a procedure is pretty straightforward but locating the right cell in Excel
makes it a bit longer to write.
HTH
B
Brian K - Project MVP
Jan said:
I know he rejected the resource usage but their follow up sounded like
the task usage. Oh well.
S
Steve House [Project MVP]
Only problem with using an Excel pivot table is the 256 column limitation on
a worksheet. The poster wanted to have resource names as column headings,
task names as row headings, and work assigned in the cell so defined. If
there are more than 256 resources, we run out of room.
a worksheet. The poster wanted to have resource names as column headings,
task names as row headings, and work assigned in the cell so defined. If
there are more than 256 resources, we run out of room.