Add time stamp function to current code

[jcaynes]

Good Afternoon,

I currently have code that moves rows to another worksheet. We have had to add time stamps to data entries for accountability and I would like to add the time stamp function to a macro. Typically the user turns off auto-calculation while making updates, so excel formulas aren't an option. We like current features - works perfectly, we just need to add the time stamp.

The target column is J or column 10, which currently sets the macro to move the row. I would also like the time stamp added to column 11 when HR enters the initial, if possible before moving the row. Offset is (0,1).

I've tried a few variations, I am just not 'getting it'.

Any help is appreciated!

Thanks!

HR Time Stamp Addition.png

Code Is:

Please Login or Register  to view this content.