Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can a conditional formula indicate "date added" next to a text?
In a long list, witrh emty rows, I need to add frequently new names, if there
is a way that a formula adds the date that name were added, it would be great! Any ideas? |
#2
|
|||
|
|||
One way you could do this is with a worksheet change event. For example
if you wanted the date in column B every time data in column A was added (or changed) then: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ErrorHandler Application.EnableEvents = False If Target.Count = 1 And Target.Column = 1 Then Cells(Target.Row, 2).Value = Date End If ErrorHandler: Application.EnableEvents = True End Sub This is worksheet event code. Right click the sheet tab, select view code and paste the code in there. Hope this helps Rowan Earnest er wrote: In a long list, witrh emty rows, I need to add frequently new names, if there is a way that a formula adds the date that name were added, it would be great! Any ideas? |
#3
|
|||
|
|||
Thank you very much Rowan, it is solved!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help (Date) | Excel Discussion (Misc queries) | |||
Expired Date Formula | Excel Worksheet Functions | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions |