Updating Time when a field has been modified
-- This one is a toughy!!!!!!!
Goal: I have two colums and multiple rows. I would like to updated the first row with the time that the second row was modified. Problem: When ever the second row is modifed every-time stamp in the first colum is updated. I need to update the time in each row independently - and keep it from being modified or updated. |
Updating Time when a field has been modified
Hi Joshua,
To enter the time as a constant use Ctrl+Shift+colon To enter the date as a constant use Ctrl+Shift+semicolon To enter the date or time automatically when you update another column on the row, you can use an event macro, see http://www.mvps.org/dmcritchie/excel/event.htm#autotime --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Joshua Vista Star" <Joshua Vista wrote in message ... -- This one is a toughy!!!!!!! Goal: I have two colums and multiple rows. I would like to updated the first row with the time that the second row was modified. Problem: When ever the second row is modifed every-time stamp in the first colum is updated. I need to update the time in each row independently - and keep it from being modified or updated. |
Updating Time when a field has been modified
Private Sub Worksheet_Change(ByVal Target As Range)
With Target If .Column = 2 Then .Offset(, -1).Value = Now End If End With End Sub HTH -- AP "Joshua Vista Star" <Joshua Vista a écrit dans le message de ... -- This one is a toughy!!!!!!! Goal: I have two colums and multiple rows. I would like to updated the first row with the time that the second row was modified. Problem: When ever the second row is modifed every-time stamp in the first colum is updated. I need to update the time in each row independently - and keep it from being modified or updated. |
All times are GMT +1. The time now is 09:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com