Automatic date

20 pts.
Tags:
Excel Calendars
Excel functions
Microsoft Excel 2003
How can you set up a cell to activate the current time when another cell has data entered into it? Just want to track what time DATA was entered in the other cell.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sorry everyone this is for Excel 2003…

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Blubudda
    If you wanted to use VBA, you could try inserting this code (right click on the tab of the worksheet you're working on and select "View Code") to look for changes in column A (the "Target, Range("a:a") part) and enter the date and time in column B (the Target.Offest(0,1) part which moves 1 column to the right of cell that has changed).  You might need to reformat the cells in column B to show the time and date the way you want.:

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("a:a")) Is Nothing Then
        Target.Offset(0, 1) = Now
    End If
    End Sub

    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following