Automatically Timestamp Entries in Excel - End of Column?

0

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Ā 

Answer
Discuss

Answers

0

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.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login