200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hello,
First of all thank you, for posting such amazingly helpful videos. I recently used your automatically timestamp entries workbook download and it worked brilliantly, I just wondered, is there a way to time stamp the input/amended date at the end of a column of data as opposed to a row?
Kind Regards,
Rachel
Hi! I'm glad you like the tutorial!
Here is a link to the tutorial for anyone who wants the file or video: Automatically Timestamp Entries in Excel
To do what you want, you just need to get the right reference and you could probably get it with this:
Replace:
Set myUpdatedRange = Range("F" & Target.Row)with:
Set myUpdatedRange = Cells(Cells(Rows.Count, Target.Column).End(xlUp).Row, Target.Column)It looks complex, but it's just nested range references.