I am trying to develop a view of related projects. In my workbook I have the following worksheets:
What I'm trying to solve for is some sort of view that for each master project, info is shown from the Master Project worksheet and below that row, rows for all associated entries in the lower-level project worksheets.
My thought to create the associations is by creating another worksheet I'd call 'Links':
For example, Link#1 indicates that the Master Project 1 is associated with SPI Project 2 and BKI Project 4. My objective would be for each unique item to be listed. Based on above:
- Master Projects: I enter the data into this high-level project worksheet. I enter a high-level project name that will be used to associate lower-level projects.
- SPI Projects: The data in this lower-level project worksheet is refreshed from a SharePoint site. It contains a list of lower level projects and information on them.
- BKI Projects: The data in this lower-level project worksheet is refreshed from a SharePoint site. It contains a list of lower level projects and information on them.
- Other Projects: I enter the data into this lower-level project worksheet.
What I'm trying to solve for is some sort of view that for each master project, info is shown from the Master Project worksheet and below that row, rows for all associated entries in the lower-level project worksheets.
My thought to create the associations is by creating another worksheet I'd call 'Links':
Link# | Master# | SPI# | BKI# | Other# |
1 | 1 | 2 | 4 | |
2 | 1 | 2 | 5 | |
3 | 1 | 4 | ||
4 | 1 | 1 | ||
5 | 2 | 7 | 5 | |
5 | 2 | 6 | 2 |
For example, Link#1 indicates that the Master Project 1 is associated with SPI Project 2 and BKI Project 4. My objective would be for each unique item to be listed. Based on above:
- The first section of data rows would begin with a row for Master#1 with the following below it:
- A row for SPI#2
- Row for SPI#4
- Row for BKI#4
- Row for BKI#5
- Row for Other#1
- The 2nd section of data rows would be for Master#2 with the following below it:
- Row for BKI#6
- Row for BKI#7
- Row for Other#2
- Row for Other#5