Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I record the time data is entered into a spreadsheet?
I want to record the time and date data is entered into a row on a
spreadsheet and not have it change when more data is added to the next row, using the =now() formula will update every time data is entered on the next row, I want each row of data to have a time stamp of when it was first put in. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I record the time data is entered into a spreadsheet?
On Nov 15, 10:48 am, bmk wrote:
I want to record the time and date data is entered into a row on a spreadsheet and not have it change when more data is added to the next row, using the =now() formula will update every time data is entered on the next row, I want each row of data to have a time stamp of when it was first put in. You could try this: rightclick on your worksheet = view code and enter following: Private Sub Worksheet_Change(ByVal Target As Range) Dim colInt As Byte Dim ws As String colInt = 3 '=C change to whatever column you want to enter the date ws = "sheet1" 'change to the name of your worksheet If Worksheets("sheet1").Cells(Target.Row, colInt).Value = "" Then Worksheets("sheet1").Cells(Target.Row, colInt).Value = Now() End If End Sub hth Carlo |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I record the time data is entered into a spreadsheet?
See
http://www.mcgimpsey.com/excel/timestamp.html In article , bmk wrote: I want to record the time and date data is entered into a row on a spreadsheet and not have it change when more data is added to the next row, using the =now() formula will update every time data is entered on the next row, I want each row of data to have a time stamp of when it was first put in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time formatting:data 1:30:20 entered reads in 1:30:20 pm | Excel Worksheet Functions | |||
flip spreadsheet data from row records to column record fields | Excel Discussion (Misc queries) | |||
flip spreadsheet data from row records to column record fields | Excel Discussion (Misc queries) | |||
recording the date when record was entered in cell in Excel | Excel Worksheet Functions |