Excel - Dynamic Timestamps, Auto Date Entered & Date Modified on Change (VBA)

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

[anitamcclean]

Exactly what I was looking for, thanks 😊

[RoDrGg]

Amazing, It's exactly the need I have in my job.

Thanks,

Congrats for your job!

[martingonzalez]

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.

[LP-igtg]

Unbeatable! But please to get the similar efforts for google Sheets with compilation of all the major comments of this viewer

[asadgondal]

Hi! :) How would you do a script where it keeps a record of the timestamps? Rather than just one updated time

[emmanuellesabino]

Hi ! Just a question, what if my headers starts at Row 7 ? What code do i have to include ?

[josedejesusfragozolopez]

Excelentes aportaciones, para uso de hoja de calculo. Gracias Learn Google Spreadsheets.

[manishsinghal]

I know that is in relevant question but it is possible to do "remove Spreadsheet version history i had checked all internet" through script.

[eduardomora]

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!

[hariharagupta]

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

[MM-zfys]

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.

[niharikagaikwad]

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

[cobraAH]

sir i am looking the formula for modified date time stamp regardless where cell is edited...

[sandeepreddy]

Hi If I use a Specific formula in Column A let the time stamp doesn't work could you please help

[Otisawide]

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?

[moesadr]

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.

[Dreadnought]

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"

[dentpeninde]

can you send me this script? I tried copying you, but it doesn't work for me after I actuate certain steps.

[iamjasbir]

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?

[MarinerLK]

Can I get the VBA code for this timestamp tutorial?