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
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!
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
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!!
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!!
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
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.
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"?
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
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!!
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.
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. :)
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
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.
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.
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?
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"
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
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
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
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
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.
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
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?
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.
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
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.
'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?
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!
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.
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?
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
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
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?
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
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
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
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
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.
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
Right-click the cell and change the cell formatting for the cells before the timestamp is input and see if that helps. There are other ways but this is the easiest solution usually. If that doesn't work, ask in our forum and we can find a better solution, probably with a little code. www.teachexcel.com/talk/microsoft-office?src=yt
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
This is just great. I have one question: How to do the macro, that clumn A gets the original (or input) date and time (in column E), but columns B, C, D get the date and time whet data is entered and the date and time is shown in columns F, G, H? So basically how to do the macro that every column (from A to D) gets the date and time separately upon data input. Column A (data input), column E (time stamp). Column B (data input), column F (time stamp). Column C (data input), column G (time stamp). Column D (data input), column H (time stamp). I don't need updated time. Thank you for your anwser.
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: ua-cam.com/video/VvZMuPMY4C4/v-deo.html
Sir, I need help, I have two sheets, sheet 1 and sheet 2. In sheet "1" we daily put the number of orders according to the date. In sheet "2" I am only showing the current activities. So I want to display the orders of the current date from sheet 1 to sheet 2. Which formula will be used for this activity? Thank you
Well sure there are lots of formatting options. If you upload a sample file on our forum and ask there, I can give you a more specific answer to your issue based on your data set. www.teachexcel.com/talk/microsoft-office?src=yt Otherwise, just click the iten in the Value section > Value Field Settings > Number Format
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
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!
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
One of the best macros application, code scope explanation, and neat development tutorial!
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!!
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
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!!
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
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.
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.
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"?
Did you ever figure this out because I need it too!
Great video broo, and can you explain to me why when this macro turned on the undo option (ctrl+z) is not working
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
Thanks. Can you define as a table name instead of table range?
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!!
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.
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 :))
Thanks nice one. Is there any option to use same coding for multiple data table in single excel sheet. Please advise.
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. :)
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
Great tutorial, how would I build on this code to include multiple time stamps for additional non-sequential columns?
Thank you - that was just what i was looking for
An excellently produced and delivered tutorial for a 'newbe' learning macos - Thanks!
You're welcome! Glad you liked it! :)
@@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!!
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?
I ALSO WANT THE LAST COLUMN TO SHOW WHO DID THE LAST ENTRY. DID YOU FIND THE ANSWER?
Is there anyway to automatically timestamp data entries in Excel Online? (Excel viewed in SharePoint, MS Teams, OneDrive etc.)? Thank you!
Great video-Do you know how to record the streaming data into a log for future review? Can you create graphs from it?
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.
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.
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?
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"
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
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
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.
Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in OI. THANK YOU
Thank you so much for explaining how it works!
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
Hi, how to apply the Auto Timestamp to different targets/ Columns?
Can you do this on excel table ! I tried but it didn’t work.
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
Excellent work my friend! Many thanks. A request if I may would be whether or not we can do the same with google sheets?
I have no idea.
Very clear explanation.Thanks
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.
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
What if range is the whole workbook, and I only want to display the updated date/time in one cell?
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?
צת .תמ ננ מ מנמ מ !צ מ! מ
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.
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
Hi is it possible to include seconds in timestamp? Newbie here
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 ?
can i ask question? i used excel 2010 but it doesn't work. what would i do. thank in advance. (phillipines)
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?
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.
'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?
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!
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.
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?
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
It is not working as my tablerange is formulated.. is there any other method for that?
I mad a data entry form with macro from another youtube tutorial, but there is no timestamp option. Is there a way we can add the time stamp feature?
Excellent work
Simple ....... easy
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
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?
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
Thanks for sharing the same.
But, Undo (Ctrl+Z) is not working on this method....
Hi, where do I go to download the formula? Can you please assist with this?
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.
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
Hey first of all awesome tutorial!
Is there a way to lock the dat column?
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
when i lock certain column, the time staps doesnt work, i get something like debug, any help here
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
What if I want the last updated date and time to appear in one cell only?
How do i run this in the same sheet for multiple cells?
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.
The code is really good, Thankyou. But the time stamp doest change when the value is updated through the formula.
I have signed in and out many times but I can't download the training file. Anyone can just share the VBA code please?
What if I want the time stamp on the left of the data entry?
Hi, thank you this works perfectly on the day but the code disappears the next day, how can i save it?
Hi thank you but how can i get the copy code? pls
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 :)
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
yes, I should Subscribe. Explained In a Great Way!
Thankyou
Great macro m8, is it any chance that only will show me the time only without date? Was trying custom formating but always shows date, mega thx
Right-click the cell and change the cell formatting for the cells before the timestamp is input and see if that helps. There are other ways but this is the easiest solution usually. If that doesn't work, ask in our forum and we can find a better solution, probably with a little code. www.teachexcel.com/talk/microsoft-office?src=yt
How do I download the workbook so that I can get the formula?
Great instructions!!!
I tried this in Office 365 Excel and does not work... it does not display the date not the updated date
than you this is so amazing! it works perfectly
after pressing 'alt 11' the page that opens does not show a sheet to select
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.
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
error 424!, "object required",
please tell what to do ??
Problem is that I'm using pivot tables and once I've captured data in any column before F, I can't remove it
I found the Excel document "Automatically Timestamp Entries in Excel", but where is the Macro coding?
Should be in Sheet 1 - you could right click the sheet tab and click View Code and that should also take you there.
This is just great.
I have one question:
How to do the macro, that clumn A gets the original (or input) date and time (in column E), but columns B, C, D get the date and time whet data is entered and the date and time is shown in columns F, G, H?
So basically how to do the macro that every column (from A to D) gets the date and time separately upon data input.
Column A (data input), column E (time stamp).
Column B (data input), column F (time stamp).
Column C (data input), column G (time stamp).
Column D (data input), column H (time stamp).
I don't need updated time.
Thank you for your anwser.
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.
awesome tutorial! Thanks
I have downloaded the file and wrote thing in the range defined and nothing happens.
Thanks alot as you just saved me alot of time and a big headache
Thanks for the tutorial. It's not working for my excel workbook though.
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.
Thanks for the video, but the code disappears Everytime I restart my PC . How do I permanently save it
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: ua-cam.com/video/VvZMuPMY4C4/v-deo.html
How to sort, Filter Data With dates when it includes time stamp
Excellent!!
Sir, I need help, I have two sheets, sheet 1 and sheet 2. In sheet "1" we daily put the number of orders according to the date. In sheet "2" I am only showing the current activities. So I want to display the orders of the current date from sheet 1 to sheet 2. Which formula will be used for this activity?
Thank you
You’re a star mate!
Thanks, really great!
Hi, I am getting an runtime error " Run-time error '-2147417848 (80010108)':" How can I fix this. But overall the video is really helpful
You are the best
wow, this is what I was looking for. Greatr job, thanks! :)
Very nice.. It works...
hi there. i want amount in Lac on my Pivot Table is there any number formatting ??? Plz Help
Well sure there are lots of formatting options. If you upload a sample file on our forum and ask there, I can give you a more specific answer to your issue based on your data set. www.teachexcel.com/talk/microsoft-office?src=yt Otherwise, just click the iten in the Value section > Value Field Settings > Number Format
thanks for reply i uploaded my sample file
Do you still check this account TeachExcel?
Good job