How to insert update date

**BrghtEyes28** · 07-01-2008, 02:41 PM

If you have two columns, is it possible to have column B put in the date that data was added to column A?

**se1429** · 07-01-2008, 04:38 PM

Switch to visual basic editor.
Click on the name of your sheet in project explorer at your left.
On the right pane select "Worksheet" from the left drop down and select "Change" from the right drop down.
Now you are in the Worksheet_Change event.
Copy this code between "Private Sub Worksheet_Change" and "End Sub".

Please Login or Register  to view this content.

Now whenever you change a cell in column "A" the next cell in column "B" will be updated with date and time.

Related Link:
http://www.exceldigest.com/myblog/20...ined-function/

Please let me know if you get the expected result.

**BrghtEyes28** · 07-02-2008, 10:47 AM

This worked great! And it was so easy to use! Thanks again.

**se1429** · 07-02-2008, 04:39 PM

You are welcome.

Thanks for your reply.

**sohaibsyeed** · 12-08-2012, 09:24 AM

Works well!!
Thanks.

**mattdurbin** · 11-26-2013, 11:47 AM

Hi

I know this is an old post but this works great for me except when i get to column AA - AF
I doesn't register anything or post the date next to it

Is there a way it can do this?

**Fotis1991** · 11-26-2013, 11:53 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.