putting dates next to entries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

peter - 22 Oct 2005 01:34 GMT

I don't know Excel too well. I have a running spreadsheet with new
entries each day. Is there a way that I can have Excel automatically
put the date in the next column? Whenever a cell in entered or
modified, it would enter that date in the next cell.

Thanks,

Peter

Reply to this Message

Gary''s Student - 22 Oct 2005 11:20 GMT

Hi Peter:

The easy way to enter the date is to click on the cell and type CNTRL ;

It can be done automatically, but that requires VBA coding

Signature

Gary''s Student

> I don't know Excel too well. I have a running spreadsheet with new
> entries each day. Is there a way that I can have Excel automatically
[quoted text clipped - 4 lines]
>
> Peter

Reply to this Message

Gord Dibben - 22 Oct 2005 19:14 GMT

Peter

This would require event code behind the worksheet.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in a cell in Col A
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
If Excel.Range("A" & n).Value <> "" Then
Excel.Range("B" & n).Value = Date
End If
End If
enditall:
Application.EnableEvents = True
End Sub

To implement this..............

Right-click on the sheet tab and "View Code".

Copy/paste the above event code into that module.

Whenever you enter or edit data in any cell in column A, the date will be
entered in column B

Gord Dibben Excel MVP

>I don't know Excel too well. I have a running spreadsheet with new
>entries each day. Is there a way that I can have Excel automatically
[quoted text clipped - 4 lines]
>
>Peter

Reply to this Message

peter - 22 Oct 2005 19:48 GMT

Hey Gord, that worked real well for columns a and b. How do I do it
if I need the same thing in other coulmns?

Thanks!

Peter

Reply to this Message

Gord Dibben - 22 Oct 2005 20:27 GMT

Peter

That would depend upon what your "other columns" are and where you would like
to have the timestamp entered.

In the code provided, you could change the Target.Cells.Column = 1 to another
column number.

The "A" and "B" can be altered.

Have a look at John McGimpsey's site on this subject.

http://www.mcgimpsey.com/excel/timestamp.html

Specifically the DateTimeStamp Macro which can be called by event code.

Gord

>Hey Gord, that worked real well for columns a and b. How do I do it
>if I need the same thing in other coulmns?
>
>Thanks!
>
>Peter

Reply to this Message

peter - 22 Oct 2005 22:45 GMT

Works like a charm, Gord! Thank you so much!

Peter

Reply to this Message

Gord Dibben - 23 Oct 2005 18:43 GMT

Thanks for the feedback Peter.

Gord

>Works like a charm, Gord! Thank you so much!
>
>Peter

Reply to this Message