Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i keep a time/date register of every change occurred in a c
I create a validation cell (emited, approved, delivered) and I wanted to get
a time/date register of every change ocurred in these status. How? |
#2
|
|||
|
|||
Try this. Create a dynamic named range. I created in a seperate sheet named "Log": Enter "Log" into cell A1 in the "Log" sheet. Choose InsertNameDefine from the menu bar. Type Log into The Names in Workbook box Type = OFFSET(Log!$A$1, COUNTA(Log!$A$A),0,1,2) into the Refers To: box On the sheet where your validation cell is, Right click on the Tab and choose View Code. Paste the following into the code window Private Sub Worksheet_Change(ByVal Target As Range) Dim rngLog As Range If Target.Address = ("$A$1") Then Set rngLog = Sheets("Log").Range("Log") rngLog.Cells(1, 2) = Now() rngLog.Cells(1, 1) = Range("$A$1") End If End Sub Let me know if this works. Matt "Paulo Matos" wrote: I create a validation cell (emited, approved, delivered) and I wanted to get a time/date register of every change ocurred in these status. How? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change FORMAT | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) |