Capture of Prior Information

[Datatellsall2]

Hello,

As a team, we use an excel to document accomplishments for each project we are working on. We make updates to the accomplishment section in the excel document every 2 weeks. We are looking for an automatic way to roll-up accomplishments from prior weeks into one column.

Our initial thought would be to have a column for each date (26 columns) to capture those 2 weeks of accomplishments, but we are trying to determine if there is an auotmatic way to do this, without having to create and input into 26 different columns.

Here is the layout of the excel doc:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Initiative[/TD]
[TD]Initiative Description[/TD]
[TD]Accomplishments (current week)[/TD]
[TD]Accomplishments (consolidation of comments form prior weeks) - trying to make this auto populated[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Test 1[/TD]
[TD]- Worked with Tim[/TD]
[TD]- Worked with John on phase 1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Test 2[/TD]
[TD]- Completed phase 2; phase 3 to begin next week[/TD]
[TD]- Worked with Isac on phase 1; UAT to occur; obtaining feedback from project team[/TD]
[/TR]
</tbody>[/TABLE]


Thanks,
M