Does anyone have a suggestion how to go about populating and maintaining client ws's from a host, or master ws of data? The table below is what the master worksheet will look like and contain.
I need to figure out how to auto-populate / maintain:
Known factors:
[TABLE="class: grid, width: 857, align: left"]
<colgroup><col><col><col><col span="3"><col></colgroup><tbody>[TR]
[TD]PROJECT[/TD]
[TD]TASK LIST[/TD]
[TD]OUTCOME[/TD]
[TD]SMART GOAL[/TD]
[TD]METRIC[/TD]
[TD]OWNER[/TD]
[TD]EXEC[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]CS1, CS2, AR2[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]CEO[/TD]
[TD]PRES[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]CS3[/TD]
[TD]SCMGR[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]TD3[/TD]
[/TR]
[TR]
[TD]TD4[/TD]
[/TR]
[TR]
[TD]TD5[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]CS1, AR3, SC3[/TD]
[TD]CSMGR[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]TD3[/TD]
[/TR]
[TR]
[TD]TD4[/TD]
[/TR]
[TR]
[TD]TD5[/TD]
[/TR]
[TR]
[TD]TD6[/TD]
[/TR]
[TR]
[TD]TD7[/TD]
[/TR]
[TR]
[TD]TD8[/TD]
[/TR]
[TR]
[TD]TD9[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]SCMGR[/TD]
[TD]SCMGR, CSMGR[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]TD3[/TD]
[/TR]
[TR]
[TD]TD4[/TD]
[/TR]
[TR]
[TD]TD5[/TD]
[/TR]
[TR]
[TD]TD6[/TD]
[/TR]
[TR]
[TD]TD7[/TD]
[/TR]
[TR]
[TD]TD8[/TD]
[/TR]
[TR]
[TD]TD9[/TD]
[/TR]
[TR]
[TD]TD10[/TD]
[/TR]
[TR]
[TD]TD11[/TD]
[/TR]
[TR]
[TD]TD12[/TD]
[/TR]
[TR]
[TD]TD13[/TD]
[/TR]
[TR]
[TD]TD14[/TD]
[/TR]
</tbody>[/TABLE]
I need to figure out how to auto-populate / maintain:
- In a CS1 ws the details about Project 1 & Project 4
- In a CEO ws the details about Project 2
- In a AR3 ws the details about Project 4
- And so on
Known factors:
- New projects will be added as time goes on
- Tasks can be added or retired as time goes on
- Details on projects can change as it goes along and the client ws would need to be maintained based on host inputs
- The PROJECT column will always be merged
- The TASK LIST will never be merged
- Other columns may or may not be merged
[TABLE="class: grid, width: 857, align: left"]
<colgroup><col><col><col><col span="3"><col></colgroup><tbody>[TR]
[TD]PROJECT[/TD]
[TD]TASK LIST[/TD]
[TD]OUTCOME[/TD]
[TD]SMART GOAL[/TD]
[TD]METRIC[/TD]
[TD]OWNER[/TD]
[TD]EXEC[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]CS1, CS2, AR2[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]CEO[/TD]
[TD]PRES[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]CS3[/TD]
[TD]SCMGR[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]TD3[/TD]
[/TR]
[TR]
[TD]TD4[/TD]
[/TR]
[TR]
[TD]TD5[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]CS1, AR3, SC3[/TD]
[TD]CSMGR[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]TD3[/TD]
[/TR]
[TR]
[TD]TD4[/TD]
[/TR]
[TR]
[TD]TD5[/TD]
[/TR]
[TR]
[TD]TD6[/TD]
[/TR]
[TR]
[TD]TD7[/TD]
[/TR]
[TR]
[TD]TD8[/TD]
[/TR]
[TR]
[TD]TD9[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]TD1[/TD]
[TD]WIN![/TD]
[TD]Be SMART[/TD]
[TD]Do great[/TD]
[TD]SCMGR[/TD]
[TD]SCMGR, CSMGR[/TD]
[/TR]
[TR]
[TD]TD2[/TD]
[/TR]
[TR]
[TD]TD3[/TD]
[/TR]
[TR]
[TD]TD4[/TD]
[/TR]
[TR]
[TD]TD5[/TD]
[/TR]
[TR]
[TD]TD6[/TD]
[/TR]
[TR]
[TD]TD7[/TD]
[/TR]
[TR]
[TD]TD8[/TD]
[/TR]
[TR]
[TD]TD9[/TD]
[/TR]
[TR]
[TD]TD10[/TD]
[/TR]
[TR]
[TD]TD11[/TD]
[/TR]
[TR]
[TD]TD12[/TD]
[/TR]
[TR]
[TD]TD13[/TD]
[/TR]
[TR]
[TD]TD14[/TD]
[/TR]
</tbody>[/TABLE]