Project Schedule 'Mash-ups' to create Master Program Schedule?
I'd like to be able to link five project schedules within a program and as I see things, this can be done two ways; 1) five separate schedules, all of which use a set of common program milestones and task dependencies linked between project schedules, or 2) mashing all of the project schedules together into one sheet, but being able to view separate project schedules through the application of filters using (e.g.) a column named 'project'.
Has anyone else tried this? I appreciate there may be more to the second option than meets the eye and would prefer to benefit from the wisdom and experience of others before I waste a week messing around.