Learn how to create an Excel VBA script to automatically add date entered and date modified timestamp columns to your data. #excel #timestamp #vba #date
Пікірлер: 45
@anitamcclean37022 ай бұрын
Exactly what I was looking for, thanks 😊
@ExcelGoogleSheets2 ай бұрын
You're welcome 😊
@LP-ig8tg11 ай бұрын
Unbeatable! But please to get the similar efforts for google Sheets with compilation of all the major comments of this viewer
@martingonzalez13322 жыл бұрын
Hello, This was extremely helpful and got me halfway to figuring out the VBA code - there is a dynamic route that I am trying to figure out. What if we have a "Range" of columns that should someone change, the date modified would update as well(but its only that one column that would need to update realtime). To better explain, I have other Column Headers other than "notes", but the date modified offsets from my designated Date Modified Column. I need the Date Modified Column to remain static. Hope this makes sense.
@Ro0Dr1Gg04 жыл бұрын
Amazing, It's exactly the need I have in my job. Thanks, Congrats for your job!
@ExcelGoogleSheets4 жыл бұрын
great!
@Otisawide7 ай бұрын
What if the notes column is the automatic column that update by the unique function from other table. Thus, the cell will fill up without we are typing. Does the timestamp will calculate as well?
@fahadkafrawi79962 жыл бұрын
Perfect content. Thank you!
@ExcelGoogleSheets2 жыл бұрын
I appreciate it!
@eduardomora2662 Жыл бұрын
Very well done video. Similar to what you present here, can you provide a screen print of codes for: Entry Date/Time Stamp; Modified Date/Time Stamp; but also Username of the person that entered the initial entry and modification entry? One other point of interest - on the same sheet, Sign-off Date/Time Stamp; Resign-off Date/Time Stamp; and Username for both here as well. Note, I tried created Entry Date/Time Stamp; Modified Date/Time Stamp and Sign-off Date/Time Stamp; Resign-off Date/Time Stamp myself, but the Entry input cell affects the Resign-off Stamp along with the Modified Date/time Stamp. Thanks!
@iamjasbir2 жыл бұрын
Thanks for the video. I have a question. I want to add a time stamp whenever any changes are done on whole workbook. Can you please suugest how can we do that?
@ExcelGoogleSheets2 жыл бұрын
If you double click on the Workbook object in the editor and select it from the dropdown there is a SheetChange event
@enefiokjames2052 жыл бұрын
@@ExcelGoogleSheets Many thanks for the detailed explanation. But after selecting the SheetChange event what next, do we just copy the code or we need to reference each sheet? Please help throw more light on this.
@asima4464 Жыл бұрын
@@enefiokjames205 did you find a solution?
@cobraAH19 ай бұрын
sir i am looking the formula for modified date time stamp regardless where cell is edited...
@dentpeninde3 жыл бұрын
can you send me this script? I tried copying you, but it doesn't work for me after I actuate certain steps.
@josedejesusfragozolopez63964 жыл бұрын
Excelentes aportaciones, para uso de hoja de calculo. Gracias Learn Google Spreadsheets.
@ExcelGoogleSheets4 жыл бұрын
Gracias!
@emmanuellesabino14963 жыл бұрын
Hi ! Just a question, what if my headers starts at Row 7 ? What code do i have to include ?
@manishsinghal18744 жыл бұрын
I know that is in relevant question but it is possible to do "remove Spreadsheet version history i had checked all internet" through script.
@MM-zf9ys2 жыл бұрын
Hey man, This video is great. The best I found on the topic. Would it be possible to do one using tables and referring to the table column name. I have been trying to do this and unable to.
@ExcelGoogleSheets2 жыл бұрын
ActiveSheet.ListObjects("myTable").ListColumns("Category").Range.Select should select the column, so ActiveSheet.ListObjects("myTable").ListColumns("Category").Range.Column will most likely give you the right column number.
@sandeepreddy14143 жыл бұрын
Hi If I use a Specific formula in Column A let the time stamp doesn't work could you please help
@hariharagupta56383 жыл бұрын
Hi Sir, I have 5 sheets in the excel, but i modified only 2 sheets on the particular day, but the remain 3 sheets are updated an week ago, so the 2 sheets which modified today should say the today's date, the remain 3 should show the last modified date only...so i will understand that which sheet when it has been modified, can you help to make the video on this please
@niharikagaikwad28653 жыл бұрын
Hii, Great Video man! What code can I use if "As soon as I enter my data, I want to fetch that same data from another worksheet and paste the value next to it in my current worksheet (in place of the timestamp)". I really need help on this
@asadgondal37463 жыл бұрын
Hi! :) How would you do a script where it keeps a record of the timestamps? Rather than just one updated time
@moesadr33422 жыл бұрын
Would someone be able to share a copy of this template/ file and /or the Final VBA code with me please? I think I missed a line or two and would appreciate it.
@Dreadnought422 Жыл бұрын
Great coding. is there a way to do this with multiple headers on difrent row numbers?(16:58) "ColumnHeader = cells (x,x,x,x,x, target.column).value"
@ExcelGoogleSheets Жыл бұрын
I don't understand what your headers looks like from your comment.
@Dreadnought422 Жыл бұрын
@@ExcelGoogleSheets My ColumnHeaders would be in Row 1, 10, 19,.... but with your coding that doesn't work. How would I make that work?
@MarinerLK2 жыл бұрын
Can I get the VBA code for this timestamp tutorial?
@redhaakhund12713 жыл бұрын
👍👍👍👍👍
@jeremybutler93803 жыл бұрын
Can you send a link of the workbook?
@blackegale99112 жыл бұрын
iam not programmer but i need the code written to add it plz
@BBBB-sl3bq4 жыл бұрын
Hi thanks for this videio, could you write the entire formula/code for timestamp. It would be easier for me to look at the code as I review the video.
@Holacanada1233 жыл бұрын
Same question. Sometimes, i cant follow up :(
@josephcosgriff60412 жыл бұрын
When I insert row I get application define or object define error. Is there a solution to this?
@ExcelGoogleSheets2 жыл бұрын
What your vba code?
@josephcosgriff60412 жыл бұрын
@@ExcelGoogleSheets just saw your reply. Here is my code, the updatedColumn is my modifiedColumn if referencing. I'm trying to create a pass down log. another issue I'm having is deleting a row once the information has been viewed by everyone, this is the larger challenge than inserting. When I delete the row I get a timestamp in a new column, and two new additional columns are created in my table. Not sure if I'm explaining it well. New to VBA. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False columnlist = Array("Topic", "Followup", "Updated", "Initial", "Airport") updatedColumnHeader = "Updated" createdColumnHeader = "Created" rowStart = 2 rowEnd = 100 headerRow = 1 numberOfColumnsToSearch = 10 columnHeader = Cells(headerRow, Target.Column).Value isInlist = Application.Match(columnHeader, columnlist, 0) If Not IsError(isInlist) And Target.Row >= rowStart And Target.Row
@aushuaushuaushu4 жыл бұрын
would you say that VBA is better then app scripts?
@ExcelGoogleSheets4 жыл бұрын
Depends on what you do. For reactive things like this, Excel being native desktop application, it works much faster, therefore you have better experience. With Google Sheets after every change you have to wait forever until it sends the change to the server, gets it done and then sends back the results, so you end up with laggy weird experience.
@aushuaushuaushu4 жыл бұрын
@@ExcelGoogleSheets I see what you mean, whenever I try to use the onEdit() on gas it always seems so laggy, I was really impressed by excel's speed. Thanks for the video man.
@prashantk53852 жыл бұрын
I'm getting error "compile error next without for in vba".. pls help
@ExcelGoogleSheets2 жыл бұрын
what's your code?
@ephemeral2429 Жыл бұрын
Did you ever figure out how to fix the next without for error? Still struggling here.