I need a help with a macro to store historical data in excel

[m.hamadeh]

Hello team,

I track task progress. However, due date keep changing every time. I need to be able to have a snapshot for current data using a button or command.

At the bottom hit the current tasks due dates should be copied to another sheet with the header of the hit date “today date”. If the task was the status “closed” no need to copy its data anymore.

Data as displayed below, Appreciate your help.

sheet 1:
[TABLE="width: 422"]
<tbody>[TR]
[TD]Tasks[/TD]
[TD]due date[/TD]
[TD]status[/TD]
[/TR]
[TR]
[TD]task1[/TD]
[TD]19-Jan-13[/TD]
[TD]open[/TD]
[/TR]
[TR]
[TD]task2[/TD]
[TD]25-Jan-13[/TD]
[TD]open[/TD]
[/TR]
[TR]
[TD]task3[/TD]
[TD]26-Feb-13[/TD]
[TD]open[/TD]
[/TR]
[TR]
[TD]tash4[/TD]
[TD]3-Jan-13[/TD]
[TD]open[/TD]
[/TR]
[TR]
[TD]task5[/TD]
[TD]15-Dec-12[/TD]
[TD]closed[/TD]
[/TR]
</tbody>[/TABLE]

sheet2:
[TABLE="width: 573"]
<tbody>[TR]
[TD]Tasks[/TD]
[TD]snapshot date1[/TD]
[TD]snapshot date2[/TD]
[TD]snapshot date3[/TD]
[TD]snapshot date4[/TD]
[TD]snapshot date5 etc....[/TD]
[/TR]
[TR]
[TD]task1[/TD]
[TD]19-Jan-13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task2[/TD]
[TD]25-Jan-13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task3[/TD]
[TD]26-Feb-13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tash4[/TD]
[TD]3-Jan-13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task5[/TD]
[TD]15-Dec-12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Best regards,

m.hamadeh

 

[m.hamadeh]

Please I need some help