B
BorisS
Sorry if this will be confusing in explanation, but here is what I need:
I need a report that shows the following (sorted in order up to column 4):
Text1 Level 1 Task Name Start Date End Date
(Estimated) Resource Notes
In case the formatting above does not show clearly, there are 6 columns to
the report. Basic definition:
I work with several operating companies in my business (investment). I
oversee several different ongoing projects within each of the companies.
With the assistance of a macro provided by Jan back in October (haven't
revisited the topic since getting frustrated with getting this report done
back then) I now have, in Text1, the name of each of the companies.
Specifically, the way the project is set up is:
Level 0 = Company Name
Level 1 = Project Name
Level 2-x = task and subtasks
I am looking to produce a report, which will basically show me, by company,
what major projects I have going on there, which tasks are at what stage
(based on start and end dates), and who within the companies I have assigned
to work on these projects.
The reason I had to make the Text 1 field equivalent to Level 0 is because
for every task, I need to know which company it refers to. I have several
companies, for example, where there is a "Systems Review" project/task. When
I see this report, I have to be able to tell which company I am specifically
talking about in looking at the task line.
Hope this makes sense. Any detailed help (and unfortunately I am an Excel
whiz, Word half-whiz, and Project idiot) on how to get this set up and
working would be greatly appreciated. Again, to the extent the Text1 field
helps in getting the report to show what I've described, that part has been
solved (in other words, I know how to get the company name into the Text1
field and it's there for the use in a report).
I need a report that shows the following (sorted in order up to column 4):
Text1 Level 1 Task Name Start Date End Date
(Estimated) Resource Notes
In case the formatting above does not show clearly, there are 6 columns to
the report. Basic definition:
I work with several operating companies in my business (investment). I
oversee several different ongoing projects within each of the companies.
With the assistance of a macro provided by Jan back in October (haven't
revisited the topic since getting frustrated with getting this report done
back then) I now have, in Text1, the name of each of the companies.
Specifically, the way the project is set up is:
Level 0 = Company Name
Level 1 = Project Name
Level 2-x = task and subtasks
I am looking to produce a report, which will basically show me, by company,
what major projects I have going on there, which tasks are at what stage
(based on start and end dates), and who within the companies I have assigned
to work on these projects.
The reason I had to make the Text 1 field equivalent to Level 0 is because
for every task, I need to know which company it refers to. I have several
companies, for example, where there is a "Systems Review" project/task. When
I see this report, I have to be able to tell which company I am specifically
talking about in looking at the task line.
Hope this makes sense. Any detailed help (and unfortunately I am an Excel
whiz, Word half-whiz, and Project idiot) on how to get this set up and
working would be greatly appreciated. Again, to the extent the Text1 field
helps in getting the report to show what I've described, that part has been
solved (in other words, I know how to get the company name into the Text1
field and it's there for the use in a report).