+ Reply to Thread
Results 1 to 3 of 3

I want to have the date entered in cell O3 when Completed is chosen

  1. #1
    Registered User
    Join Date
    09-03-2012
    Location
    Christchurch New Zealand
    MS-Off Ver
    Excel 2013
    Posts
    45

    I want to have the date entered in cell O3 when Completed is chosen

    I want to have the date entered in cell O3 when Completed is chosen from a drop down list in M3, the date needs to stay as the date completed was entered
    I need this to be repeated from cell O3 M3 all the way down the work sheet.

    I Have tried to write up a code but i am a novice

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("M3")) Is Nothing Then_

    Target.Offset(-1, 0).Value = Now

    End Sub

    Any Suggestions
    I have attached worksheet
    See April Sheet
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-27-2012
    Location
    cebu, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    210

    Re: I want to have the date entered in cell O3 when Completed is chosen

    I added this on the December worksheet VBA codes - under selection change

    Please Login or Register  to view this content.
    *this procedure only works for December worksheet.
    *the code does not initialize if you have an empty cell in the middle of cells with contents

    do you want it to work in the entire column? regardless where the row is on column O?
    don't worry, there's a lot of people that are far more confused than you
    but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.

  3. #3
    Registered User
    Join Date
    09-03-2012
    Location
    Christchurch New Zealand
    MS-Off Ver
    Excel 2013
    Posts
    45

    Re: I want to have the date entered in cell O3 when Completed is chosen

    Thank you for your reply
    I need it to go down the whole collum and i need it to enter the date in the corresponding row
    E.g when completed is selected in M3, cell O3 shows the date that completed was selected
    this goes down the sheet so that everytime cell M? has completed the corresponding cell row in O shows the date that completed was selected
    Cheers

+ Reply to Thread

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