Capture of Prior Information

Datatellsall2

New Member
Joined
Jul 17, 2018
Messages
23
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:

InitiativeInitiative DescriptionAccomplishments (current week)Accomplishments (consolidation of comments form prior weeks) - trying to make this auto populated
1Test 1- Worked with Tim- Worked with John on phase 1
2Test 2- Completed phase 2; phase 3 to begin next week- Worked with Isac on phase 1; UAT to occur; obtaining feedback from project team

<tbody>
</tbody>


Thanks,
M
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,095,395
Messages
5,444,225
Members
405,274
Latest member
go2nivas

This Week's Hot Topics

Top