Automatically Timestamp Data Entries in Excel

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

How to make data entry simple and accountable by having each entry timestamped and recorded in Excel. This tutorial covers simple and complex methods to timestamp your data as well as to record the last time an entry in the spreadsheet was updated.

The last example in the tutorial covers an in-depth explanation of how to customize a macro to timestamp data entries for you and also suggestions on how you could protect the timestamped data in Excel.

[TeachExcel]

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[ferchofarias]

One of the best macros application, code scope explanation, and neat development tutorial!

[janellegriego]

Thank you so much! I have been searching for a solution to a static date/time stamp for several months. This tutorial finally gave me an answer.

[mrarshidbhat]

yes, I should Subscribe. Explained In a Great Way!
Thankyou

[mikes]

This is great! Thank you. I had a suggestion for the range section.

If you want to use a whole column vs. range use the following code change:
Set myTableRange = Range ("A:A, B:B, C:C, D:D"). ' You can add as many columns as you like

I had a problem when I click in the cell and so not change anything, it was updating the date time. Turned out to be a user error, I had the private sub as worksheet_selectionchange, not worksheet_change.

Thanks again!!

[richardbannister]

Great tutorial, how would I build on this code to include multiple time stamps for additional non-sequential columns?

[AndrewSmith-vvvh]

An excellently produced and delivered tutorial for a 'newbe' learning macos - Thanks!

[laszlobogdan]

wow, this is what I was looking for. Greatr job, thanks! :)

[roel]

Looks like i got it to work now, great code!!! thanks. One thing, how do you code it when you delete the date it deletes the input time and update time as well

[erikengels]

Hi, great instructions! Can we modify the VBA code that it allows the user of the workbook to paste multiple rows at once, and get automatically the time stamp in the given columns for each row?

[janjosey]

Thanks for this. Works great when entering data directly onto worksheet. When I use a form to enter data, the dates are not updating. I downloaded your example and notice it also does not update the timestamps from a data entry form. Thanks so much. :)

[umairhanfi]

lovely. that was super easy. thank you so much for explaining it in a jiffy! you solved my query and gave me a solution that i had been looking fir days!!!..what a lovely code!!

[matthewmusselwhite]

Thank you so much for explaining how it works!

[negociosonline]

Muito obrigado, trabalhar com excel é liberdade e muita economia de tempo. Estou tentando converter o Timestamp na api da Binance para esse formato Excel e ainda tenho que converter no formato brasileiro.

[trelzy]

Right click on the timestamp template tab at the bottom of the downloaded worksheet.
Click on View Code, select all and then paste into macro.

[eduardocabuya]

Awesome work man, thanks a lot, i don't know any of this programs or coding and i made it work for a specific job, plus english is not my first language

[JD-ksnv]

Great video-Do you know how to record the streaming data into a log for future review? Can you create graphs from it?

[leejinghao]

thanks for the wonderful tutorial as always! I have tried the code it went successful however I was unable to delete the timestamp during wrong input, any idea to delete the row for wrong input ? looking forward to hear from you. Thanks

[jonpye]

Hi Teach Excel - What a great method you have of putting things over. There are other good tutorials to be watched, but you can't help sensing that the tutors just hold that little thing back which is quite important. If you were not a bit savvy to be able to fill in the blanks you could easily get lost. However you applied reasoning and very good explanation. Top job.

[knowhow]

Thanks for this Awesome Video and I've already subscribed to your wonderful channel. Would you please share a link of the Macro file. Thanks.