Auto delete info of a cell after 24 hours

Hello dear people,

I hope you can help me once again with a requirement I have, you usually save my life

I was wonder if it's possible that an Excel sheet delete the info each 24 hours of certain cells that I previously indicate. I'll attach and image on this post, so that you understand me better

Example.jpg

I have some information in the cells of the A column, I need to use this information daily but due to the type of work I can't re-use the same information before 24 hours have elapsed. After 24 hours I can use the information again. This is just an example of 10 row but really I have a lot of rows with information.

it occurred to me to create a button in this case the "Button 1", which I use to write the Date and the exact hour when I finish to use the information of each cell of Column A. I assigned a VERY SIMPLE macro to the Button which is:

Please Login or Register  to view this content.

When I'm in any cell of B column and I click this button, the actual time and the hour is written. It's worth emphasizing that all the cells in the B column have the following format d/mm/yy hh:mm as you can appreciate in the image. Having this on the next day I already have the hour where I used each information.


What is not profitable is that I need to clean the cells of the B column in the next day and closely check each hour because the information isn't used in order and the hours are not in consecutive form like in the image of the example.

It will good for me if the in the column B I would've an asterisk or any other sign, no matter what, that I put there when I finished use the information of that row and then sign disappears automatically after 24 hours, I supposed it could be something sync with the system clock, I don't know.

I hope you can help me with this, excuse me if I need help with very hard things, but I trust in the great abilities of all of you

Thank you so much!

Hello, thanks for your help! I think that maybe I was not clear enough on my requirement. I'll try to use words.

I need to modify a cell and after 24 hours the cell auto-clear all the content I put there. For example, if I write the word "Used" in a cell, starts to count 24 hours and after it, the cell comes clear. I think is so weird and I don't know if it's possible. Maybe could be possible with the internal clock of the system, I don't know.

I hope you can help me to find a solution

Wow! Wow! Wow! ...... I don't have words! You make me believe that all is possible in this world of macros! I already tested it and it works perfectly. I just changed the LifeSpan to 0.003 and then I wrote and asterisk * in the Cell A1 of the Sheet1 and after 5 minutes it dissapear! just like I wanted!....wow! i'ts just awesome.

I have some questions, I hope you can help me..

1. What's rol of the "..|Audit" sheet? I'm asking this because I need to transfer this code to excel workbook I already have created, which is the workbook where I need to have this code working. How I can transfer the Audit sheet or how I need to create this this in this old woorkbook?

2. Does the number 1 in the LifeSpan represents exactly ONE DAY (24 hours)?

3. What's happen If I save the file, close it and turn off the PC? I supposed when I open the worksheet in the next day, the code will auto make the inspection in the exact moment it opens and will clear the cells normally?

Thank you so much for your help!

This was the PERFECT SOLUTION! For my requirement! Of course I'll give you a reputation Thank you so much for your help!

Hi there, I stumbled upon this thread, for a wonderful script and this is what I am looking for!
Although I have a little question, instead of deleting the value of the cell over 24 hours, would it be possible to delete the entire row, and the next row moving up replacing the deleted row?

I have a sensor that is feeding data every 5 minutes into the spreadsheet, and I'd like to keep the row count below 500, so it would be nice if the data keep moving up within 24 hours period.

Hello, thank you very much for this excel sheet it is very helpful. But I have one question to that. Do you think I would be possible the cells would errase only its values but not the functions and formulas leading into the cells? Thank you very much for the answer.