Populate & maintain client worksheets from a host worksheet

RLCornish

New Member
Joined
Feb 11, 2014
Messages
42
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:


  • 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]
 
I don't know what happened to the table I inserted. I swear, I'm much more adept within Excel than I am this forum. Sorry about that. However, all the "TD's" are To-Do, i.e. TASKS and should be under that column.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top