Hi all,
First off, my apologies for the vague title, I appreciate it isn't very descriptive, but I'm afraid I don't really know how to summarise what I need help with in a short sentence.
A couple of months ago, I set up a document that allows Project Managers to identify the next "Stage Gates" their various Projects were expected to hit, along with a function to indicate the respective BRAG status and planned date for reaching said gate - see "Current SG Tab" in the attached file.
As you'll note from the document, the Project Name column is currently pulling the list Projects based on the indicated Programme in A4, and the remaining columns provide drop-down lists that Project Managers can then select from as required.
I have since been asked to expand the function of this particular document, in which the desired outcome is that Project Managers indicate the BRAG status for all Stage Gates (past and future), which would require that the layout of the document be similar to that shown in "Ideal SG Tab".
Unfortunately, I can't figure out how to automate the document to provide this particular layout, or anything similar to it. I would very much welcome any suggestions and ideas you may have on how to resolve this.
Many thanks in advance, and I look forward to hearing from you.
G
Bookmarks