How to make a formula to take value in database to store as history

Hi,

I'm confused in making a formula to show as history from database.
See my attachment for more explanation.

Thank you for your time.

Hi

I think Pivot Table is the answer.
Please check the attached file.
Hope this would be help you.

hi thank you.
But I dont know how it works to what I want. Could you please explain more or are there any other way beside using pivottable

The pivot table seems not update to the value in database. Remember that the database is always updated and increased. When the month change, in pivot table not shown the month. Or I'm messed in something?

If you use a volatile function like TODAY() then the date will constantly change affecting historical data. You need to add the date as a value manually

Tip: use Ctrl + ; to add the date

Thats what I want. The database date are constantly change every month. But I want to preserve the history of entry with status "New" in another sheet. How can I achieve that?

If you are manually deleting the records then use Filter the records. Copy & PasteSprcial -> Values to the archive sheet

are there any way to make the process automatic, I mean the copy & paste special to archive sheet?

Adapt my code in this post