Keep track of an action plan daily

[user520]

Hello everyone,

I'm new to VBA excel and am learning a lot today by reading threads on this forum.

I tried a few codes but none gives exactly what I wish to achieve .. So I hope that you could kindly guide me here

I have an action plan on Sheet 1 and would like to track changes daily on Sheet 2.

Action plan example
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]What[/TD]
[TD]Why[/TD]
[TD]How[/TD]
[TD]Done[/TD]
[TD]Ongoing[/TD]
[/TR]
[TR]
[TD]05/12/2017[/TD]
[TD]Clean the washing machine[/TD]
[TD]Project B[/TD]
[TD]Stop cycle[/TD]
[TD]6/12/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]06/12/2017[/TD]
[TD]Maintenance LF[/TD]
[TD]LF failure[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

This action plan is renewed daily and I would like to keep track of a sum of actions EACH DAY on Sheet 2 which are :

1. Done
2. Ongoing
3. Newly added

Here's an example of tracking table in Sheet 2

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Done[/TD]
[TD]Ongoing[/TD]
[TD]New[/TD]
[/TR]
[TR]
[TD]11/12/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/12/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13/12/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Thank you in advance for your reply.

 

[reberryjr]

Seems like a simple pivot table would give you what you're looking for. Have you tried that yet?

 

[user520]

yes, I've found what suited my need. Thank you for your reply.