control - make sure that data is updated

[Myproblem]

I need to make control to make sure data is updated
I every month do report, and each month some small amount of data (couples of cells) must be updated.
Sometimes I used to up-to-date it, because I do it manually.
I need some control tool to remind me that I should check whatever I updated data or not
any tips

 

[gardnertoo]

You could build a macro with a userform that requires you to either enter a new value in the form or click a "keep existing value" button. Once all of the values are either changed or confirmed as unchanged, the userform drops the new/old values into the appropriate cells and you're done. I suggest this on the assumption that "a few cells" does NOT mean "there are hundreds of cells, and only a few of THEM must be changed", but instead means "there are a few cells, and some or all of them must be changed". You could launch the macro on the Worksheet.Open event, or manually with a button on the sheet.

 

[Myproblem]

thanks mate
I was thinking about creating macro, but it really about 10-20 cells in total (on different sheets), to up-to-date, but I dont have any knowledge about creating macro to solve this problem
any other tips

 

[gardnertoo]

Next to each of the cells with data that must be updated or verified, you could add an "updated on" cell, and conditional format that cell so the background changes color if the "updated on" date isn't today (or isn't within X days of today)