F
Fred Newton
I have a Word/97 document that is a management summary of a series of
project reports from a dozen or so Project Managers. All their
reports have the same format and, at the top of each, in a table, is a
coloured summary letter (RAG) for each of 4 elements of their project,
overall status, cost, risk and resource. The status table is formatted
such that there are 5 rows, a header row plus one for each element and
4 columns, for element and then one each for Red, Amber and Green
The report that is sent to management has a summary page at the
beginning, followed by the dozen or so Project Manager reports. The
summary page is formatted such that, alongside the Table of Contents
(created using the Insert Field TC option on each of the project
reports), there is an additional table (manually completed at present)
showing the RAG status letters from each of the reports. Each of these
RAG status letters on the summary report is hyperlinked to the
appropriate section of the appropriate report.
Right, that's set the scene, now the question ... Is there any way I
can get the RAG status letters on the summary page (currently colour
coded Red, Amber and Green) to "auto-complete" based upon the RAG
status letters in the table at the top of each of the Project Managers
reports ?
Thanks for any help that you can provide
Fred Newton
Zurich Financial Services
project reports from a dozen or so Project Managers. All their
reports have the same format and, at the top of each, in a table, is a
coloured summary letter (RAG) for each of 4 elements of their project,
overall status, cost, risk and resource. The status table is formatted
such that there are 5 rows, a header row plus one for each element and
4 columns, for element and then one each for Red, Amber and Green
The report that is sent to management has a summary page at the
beginning, followed by the dozen or so Project Manager reports. The
summary page is formatted such that, alongside the Table of Contents
(created using the Insert Field TC option on each of the project
reports), there is an additional table (manually completed at present)
showing the RAG status letters from each of the reports. Each of these
RAG status letters on the summary report is hyperlinked to the
appropriate section of the appropriate report.
Right, that's set the scene, now the question ... Is there any way I
can get the RAG status letters on the summary page (currently colour
coded Red, Amber and Green) to "auto-complete" based upon the RAG
status letters in the table at the top of each of the Project Managers
reports ?
Thanks for any help that you can provide
Fred Newton
Zurich Financial Services