If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
putting dates next to entries
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 |
#2
|
|||
|
|||
putting dates next to entries
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 -- Gary''s Student "peter" wrote: 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 |
#3
|
|||
|
|||
putting dates next to entries
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 On 21 Oct 2005 17:34:49 -0700, "peter" wrote: 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 |
#4
|
|||
|
|||
putting dates next to entries
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 |
#5
|
|||
|
|||
putting dates next to entries
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 On 22 Oct 2005 11:48:17 -0700, "peter" wrote: 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 |
#6
|
|||
|
|||
putting dates next to entries
Works like a charm, Gord! Thank you so much!
Peter |
#7
|
|||
|
|||
putting dates next to entries
Thanks for the feedback Peter.
Gord On 22 Oct 2005 14:45:47 -0700, "peter" wrote: Works like a charm, Gord! Thank you so much! Peter |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How look up Entries from Span of Dates Example Jan 1- May 1 | James Osborne | General Discussion | 1 | May 30th, 2005 06:51 PM |
Stop Excel Rounding Dates | leinad512 | General Discussion | 1 | April 20th, 2005 04:19 PM |
converting dates into numbers | kikilein | General Discussion | 2 | October 20th, 2004 07:33 PM |
2 Que's regarding dates (matching and subtracting) | jacob farino | General Discussion | 1 | October 11th, 2004 05:11 AM |
Change Start Dates without Changing Due Dates | Beth | General Discussion | 0 | August 19th, 2004 03:44 PM |