Results 1 to 9 of 9

Enter Date in cell next to another with specific value

Threaded View

  1. #1
    Registered User
    Join Date
    11-05-2011
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    5

    Enter Date in cell next to another with specific value

    I have sheet with data in Cells C2 to E14.
    If anything is changed in Col E, I have VBA code that will input today's date into a cell (C10), which happens to be next to a cell with entry of Report Date.
    Private Sub Worksheet_Change(ByVal Target As Range)
        If Target.Column = 5 Then
            Application.EnableEvents = False
            Cells(10, 3).Value = Now()
            Application.EnableEvents = True
        End If
    End Sub

    What I want to do is change the code to add Now() next to the cell with value/entry of Report Date instead of specifying Cells(10,3)
    The cell with entry of Report Date happens to be B10. But in another sheet, that same entry may be B13.

    How would I do this? What would that code look like?

    Thanks for any assistance given.
    Attached Files Attached Files
    Last edited by AdamShack; 11-05-2011 at 06:56 PM. Reason: Marking as SOLVED

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1