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? |
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? |
Thank you very much Rowan, it is solved!
|
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com