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

Date	What	Why	How	Done	Ongoing
05/12/2017	Clean the washing machine	Project B	Stop cycle	6/12/2017
06/12/2017	Maintenance LF	LF failure			x

<tbody>
</tbody>

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

Date	Done	Ongoing	New
11/12/2017
12/12/2017
13/12/2017

<tbody>
</tbody>

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.