Automatically Timestamp Data Entries in Excel

[@TeachExcel]

MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_gIPdx4-rqGg 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[@craigwoodward7677]

Thank you - that was just what i was looking for

[@mikes4830]

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!!

[@NhungNguyen-ho5op]

is it possible if we set the code on a table type in excel? I have a habit in using table more than normal ranges

[@ferchofarias6635]

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

[@trelzy73]

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.

[@justinemiano4701]

Very helpful video! Exactly what I needed. On a separate note, how can we automatically clear the dates if the data are deleted? When I delete the row of data corresponding to the dates, the dates don't disappear automatically, so I have to delete them individually. Could you make a video about this? Thank you!

[@janellegriego6962]

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.

[@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!!

[@jonpye444]

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.

[@TeachExcel]

Thank you very much for your nice comment! I'm very happy that you found my explanation good and useful and I hope I can keep it up :))

[@AndrewSmith-vv7vh]

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

[@TeachExcel]

You're welcome! Glad you liked it! :)

[@53KJB]

@@TeachExcel I've been wanting to do this for YEARS! I've looked all over to do this and couldn't find it. THANK YOU!!

[@benignoguilarte2806]

Excellent!!

[@janjosey5642]

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. :)

[@matthewmusselwhite591]

Thank you so much for explaining how it works!

[@Riverdon-c7r]

Thanks alot as you just saved me alot of time and a big headache

[@monporoshneog4725]

Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in OI. THANK YOU

[@sudarapremathilaka1706]

Very clear explanation.Thanks

[@JD-ks2nv]

Does your course teach how to "record" a particular cell in a different book? LIke if it updates every second and I want to review what the streaming data did throughout the day-THanks

[@ranjeethrikkala6344]

Can you do this on excel table ! I tried but it didn’t work.

[@AyaGeee808]

That helped me so much getting a task done! However; is there any possible way to add more timestamps for entries to be entered in multiple columns instead of just column "E"?

[@Talon73]

Did you ever figure this out because I need it too!

[@dcsmooth]

How do you apply the code across multiple groups of columns each with their own reference cell to look for data entry? I have “Entry Date” & “Updated Date” in columns C & D respectively which I can get the code to work off of data entered into column B. But I also have to make this work in further column groups going across the sheet. Column A = Name of employee Column B = Status (Completed or In Progress) Column C = Date/Time populated when Column B is “Completed” Column D = Updated time whenever a change is made to Column B Then this same function has to work on the next group (Columns E,F,G,H) and so on.

[@samanzuca]

Thanks, it worked for a while but now it has stopped after I protected the sheet, and now it doesn't work anymore even without the protection. What can I do to solve this? thanks

[@richardbannister5172]

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

[@thatdataguy3429]

How to add input time in large data set.... Like is there any formula which we can apply for input time and then excel will fill the entire column of "INPUT TIME"

[@1128roel]

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

[@user-hn9mt8ti3o]

What if range is the whole workbook, and I only want to display the updated date/time in one cell?

[@Freemachains]

Hi Teach Excel, thanks for this video, I have a question, If i have multiple values and I want to set a date change for each value respectively,i have "shipment date", "delivery date", "invoice date", and I want to know whenever the status of an order change at each step, time change will be updated in different columns for sure, Thank you!!

[@zachoxley]

How can I integrate this into my excel form that inputs data via a Form? Seems like the macro doesn't view data entered via form the same as data entered directly into the cell.

[@JeffMartinez-dp9pd]

Hi, how to apply the Auto Timestamp to different targets/ Columns?

[@mayurmohanjigupta7802]

Thanks

[@eduardocabuya9847]

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

[@ShakeebVakkom]

Excellent work Simple ....... easy

[@TeachExcel]

Thank you! I'm glad you think so :) And if you need any help with this guy, feel free to ask on our forum, a lot of people tend to want to customize this one. www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@roddizon2242]

How do you create a macro to compared a set of time to a real time and the do a copy and paste of row of cell to another row of cell ?

[@stanTrX]

Thanks. Can you define as a table name instead of table range?

[@TheBus1974]

Thank you for the code. Works well. Wondering how I could modify a bit, using a check box to flag that the task has been completed and once clicked I would like to load the date into a cell. Would like the macro to run once the cell has been update from the check box and the cell coming back with a "true". The cell where the true is loaded into never gets a carriage return on it

[@TeachExcel]

Hi D, you can do basically anything in VBA. I'd go over to our forum and ask there and upload a sample file along with the question - if you want to learn a lot more, you can always take my full VBA course here - www.teachexcel.com/vba-course-update.php?src=yt_comment_reply_gIPdx4-rqGg

[@leejinghao6941]

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

[@Shirosh_ft._Stephen]

Great video broo, and can you explain to me why when this macro turned on the undo option (ctrl+z) is not working

[@christycox4129]

Great instructions!!!

[@AshokYadav-mf2rm]

Thanks for sharing the same. But, Undo (Ctrl+Z) is not working on this method....

[@HomeMovieEmpire]

How do i run this in the same sheet for multiple cells?

[@TP014563]

Great tutorial, very informative. In case this is shared with others to enter data, can we have an extra column showing who did the last entry?

[@fluffyhoneytina]

I ALSO WANT THE LAST COLUMN TO SHOW WHO DID THE LAST ENTRY. DID YOU FIND THE ANSWER?

[@andywintx]

after pressing 'alt 11' the page that opens does not show a sheet to select

[@abbbbbbbbi]

It is not working as my tablerange is formulated.. is there any other method for that?

[@Chris-eq2vk]

Hi TeachExcel, I’ve just come across this video and found it incredibly helpful, thank you for posting it. I do have 1 question. How can I add the username of the person who made the change into the next column. That way I can see who last updated the record? Thank you in advance.

[@mrarshidbhat]

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

[@muhammadwaqasjaved9470]

Hey thanks for describing the code. I am new to Macro and have a quick question. After using this code I am unable to delete rows manually. I am unable to delete a row when it has those two columns populated with dates. Can anyone help me in this regard? Thanks in advance.

[@ninabrillantes652]

What if I want the time stamp on the left of the data entry?

[@rey.vasquez4365]

Hi Good morning Sir..would just like to ask your assistance on how I'll be able to count the events from a single cell? basically, i have a single cell that changes from "0" to "1" vice versa. (a data from PLC that is connected to excel thru (DDE ) dynamic data exchange. and I want to record how many times it changes from 0 to 1 ...thak you

[@negociosonline40]

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.

[@Hans_Olo]

than you this is so amazing! it works perfectly

[@titantts]

awesome tutorial! Thanks

[@dranelleonardoful]

You’re a star mate!

[@mohdmuzu142]

The code is really good, Thankyou. But the time stamp doest change when the value is updated through the formula.

[@JD-ks2nv]

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

[@elyarsaeedi4264]

What if we want to stamp auto date and time on top of the column? Data rage A5:D10 and Row1 and Row2 of each column for the time and updated time. Thanks

[@SURYAVASU]

Hi there, your video is very useful. I need your help on how to use these codes twice in a sheet. For me I need a three columns as TableRange, InputTime, UpdatedTime and another TableRange, InputTime, UpdatedTime. I tried and get Compile error ambiguous named

[@crisbenmarkduque8056]

Thanks, really great!

[@jincasino594]

Hi is it possible to include seconds in timestamp? Newbie here

[@AmeliaBaljit]

Thanks for the tutorial. It's not working for my excel workbook though.

[@TeachExcel]

I can't help you if you don't describe the issue - or go to the forum on teachexcel.com and upload a sample file with an explanation of the issue.

[@nitilanchan7787]

Thanks nice one. Is there any option to use same coding for multiple data table in single excel sheet. Please advise.

[@indiananimesenpai1566]

How to sort, Filter Data With dates when it includes time stamp

[@erikengels9613]

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?

[@mikelennon1078]

I have signed in and out many times but I can't download the training file. Anyone can just share the VBA code please?

[@JamesClarke1]

Could you update the code for a scenario where the range is formatted as a table. In case I add new columns before the date columns in the future so I do not have to update the code?

[@deepanderneopaney7990]

error 424!, "object required", please tell what to do ??

[@kayode98]

You are the best

[@TheStrossicro]

Excellent work my friend! Many thanks. A request if I may would be whether or not we can do the same with google sheets?

[@TeachExcel]

I have no idea.

[@laszlobogdan4450]

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

[@yvindGranberg]

'I wanted to put the timestamps in another worksheet named data, like this; Set myDateTimeRange = Worksheets("data").Range("Y" & Target.Row), but it yellowed out on me. What did I do wrong?

[@surjolove2572]

Very nice.. It works...

[@jordanemery7069]

I want to lock cells in a row after entering the data in the cells in that row by selecting a yes or no from a drop down list at the end of that row. "is the data in this row complete?" yes = locked row. Can someone please help.

[@Rachelt78]

Hi, thank you this works perfectly on the day but the code disappears the next day, how can i save it?

[@ajaykumar-sd6pp]

Thanks Well Trainer

[@abestech7190]

great tutorial i have an issue with the code i want to let the updated time only get triggered by one new colume instead of it being triggered by the first time colume how do i do that

[@rakshitharamesh3161]

This is just good and a rare example. However I want to trigger change event when the cell value is deleted the corresponding datestamp must delete. Is it possible?

[@TeachExcel]

basically, everything is possible - give it a try and post your work on our forum and it should be easy to help :) www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@mickoo07]

Explained so simply ✌🏼👍🏻 Thanks buddy ✌🏻

[@TeachExcel]

You're very welcome! Glad you liked it :)

[@mickoo07]

I need vba macro for Trim and cleaning data. Could you help for this.

[@TeachExcel]

Yea sure, just ask your question on our forum and be specific about what you are trying to do and upload a sample excel file to illustrate the issue. It's much easier to help there than through comments here lol TeachExcel Forum: www.teachexcel.com/talk/microsoft-office?src=yt

[@shayestegall6571]

Is there anyway to automatically timestamp data entries in Excel Online? (Excel viewed in SharePoint, MS Teams, OneDrive etc.)? Thank you!

[@Linkonem]

I have downloaded the file and wrote thing in the range defined and nothing happens.

[@thatotlakedi5694]

Problem is that I'm using pivot tables and once I've captured data in any column before F, I can't remove it

[@1128roel]

I tried this in Office 365 Excel and does not work... it does not display the date not the updated date

[@Sayeef_Khan]

I have completed a file few month ago and now suddenly I need to know when did I do the last change. Can I find that past time?

[@knowhow1242]

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.

[@bighaasfly]

Really great tutorial! Thank you so much! In my spreadsheet each client has a row with various data in each cell. I have unique notes entered in all cells in column D about the respective client. How can I get the timestamp to update when I only change a note on the cell but not necessarily the cell value? Timestamp updates when I change the cell value but not when I change the note. Any counsel is much appreciated.

[@TeachExcel]

Hi, this is not the best venue for helping, go ahead and ask in our forum, along with any sample code you have, and it should be easy to help) www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@keyurs3822]

Hey thank you for the video it was really helpful. It works perfectly when single cell is added/updated but when someone takes a data dump, only the first cells are updated. Any changes in code which could help in adding timestamp in all the cells at once?

[@user-nt1bl5zx7r]

צת .תמ ננ מ מנמ מ !צ מ! מ

[@vijaykumarchoukimath2924]

Hi, thank you for the wonderful tutorial, could you pls clarify if we can also automate to capture the username who has edited or updated the cells.

[@TeachExcel]

Definitely you can - it depends how you want to store the usrename, but its easy to do - ask in our forum and include a sample file and it should be easy to help) www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@andorandor5462]

Awesome tutorial, I receive a Run-time error 91 Object Variable or With block variable not set when modifying a value in my table, any idea how to fix this? I use office 2019. thanks!

[@TeachExcel]

Andor, shoot the code into our forum and ask your question there - or upload a sample file. Then it will be easy to test it out. It is for sure a small issue.

[@lazarsavic9958]

How can i make two time stamps for example time when certain process started and then time when ended? Thx u very much this is so awesome :)

[@TeachExcel]

Depends how the process is started and ended in Excel. Ask this question in our forum and include more info, even uploading a sample file, and it will be easier to help you. www.teachexcel.com/talk/microsoft-office?src=yt

[@RPEXCELLENT]

Good job

[@valmirberisha5232]

How do I download the workbook so that I can get the formula?

[@wilainaja]

Hi thank you but how can i get the copy code? pls

[@eugenedating745]

can i ask question? i used excel 2010 but it doesn't work. what would i do. thank in advance. (phillipines)

[@nazmidaud2665]

Thank you

[@valmirberisha5232]

Hi, where do I go to download the formula? Can you please assist with this?

[@oldcode314]

I followed everything as is but when entered data on Column A then Tab, nothing appears on column E and F for the date. Please help.

[@TeachExcel]

You're gonna have to upload the file that you're using to our forum to get specific help with this issue - I'm sure it's something small but I can't debug it from here. www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@Chainer-he5zr]

Hey first of all awesome tutorial! Is there a way to lock the dat column?

[@TeachExcel]

Thanks) Unlock all cells but the Dat column and then protect the sheet and have the macro unprotect the sheet, input the timestamp, and reprotect the sheet. If you want more specific help with code examples, ask in our forum and it is much much easier to help: www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@Barchafel]

when i lock certain column, the time staps doesnt work, i get something like debug, any help here

[@pauloa.2026]

Very good and simple the video!!! Congratulations!!!

[@TeachExcel]

Thank you so much! Glad you liked it :) Let me know if you have any thoughts for future tutorials!

[@InstructorDePoy]

I found the Excel document "Automatically Timestamp Entries in Excel", but where is the Macro coding?

[@TeachExcel]

Should be in Sheet 1 - you could right click the sheet tab and click View Code and that should also take you there.

[@muhammadshafiq9840]

grate job.....

[@up16wanderer91]

How to vba window in wps

[@martintavengwa654]

Thanks for the video, but the code disappears Everytime I restart my PC . How do I permanently save it

[@TeachExcel]

You might want to store it in a personal macro workbook so it will be there for all workbooks to access. Here is a tutorial I did that explains that process: kzbin.info/www/bejne/jKe9fqiGgr5neZY

[@evilsubha6442]

3.36