Hi,

Some time I didnīt look at this again, but today founded a solution through a formula instead of using a Macro (that would solve this, but I'm not a "pro" in vba),using a circular reference I was able to hold the value of past week, you will get an alarm about his, then is a matter of going to Excel option > Formulas, and Enable iterative calculation check box, better explained here http://office.microsoft.com/en-us/ex...010066243.aspx