+ Reply to Thread
Results 1 to 7 of 7

Enter the Date when data was originally entered into another cell

  1. #1
    Forum Contributor
    Join Date
    09-25-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    152

    Enter the Date when data was originally entered into another cell

    I'm not sure if this is possible or how it can be done, but would appreciate any help or advice.

    Column A is updated frequently with data
    When Column B is updated with any information, I would like Column C to contain the date of data entry for the cell adjacent in Column A.

    So,

    Cell A3 has data entered on 01-01-14
    When Cell B3 is updated (regardless if the date), I would like Cell C3 to contain the date 01-01-14

    Cell A14 has data entered on 02-14-14
    When Cell B3 is updated (regardless if the date), I would like Cell C3 to contain the date 02-14-14

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Enter the Date when data was originally entered into another cell

    Its a bit tricky, cause of the time between the data.

    you'll need a worksheet called, AUDIT say

    then in the worksheet with the data, ran a few tests, but may req mods.

    Please Login or Register  to view this content.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Enter the Date when data was originally entered into another cell

    Hi, nathansev,

    according to what I read from the OPīs request I would not see any reason for an additional sheet but just the sheet where the data is changed.

    @Hood:
    right-click on the worksheet tab, choose View Code and paste the procedure into the Code Window:
    Please Login or Register  to view this content.
    This code will add the change for Column B in Column D (which could be omitted if not needed/unwanted). Please remember that there may only be one event called Worksheet_Change behind the worksheet, if you already are using an event of this name we would have to match the codes into one procedure.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Enter the Date when data was originally entered into another cell

    The date of change to A is populated on change to B though, so yours will put the date in C1, when A1 is changed and then D1 when B1 is changed.

  5. #5
    Forum Contributor
    Join Date
    09-25-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    152

    Re: Enter the Date when data was originally entered into another cell

    Thanks, but not quite what I was hoping for...

    For example:
    Cell A1 has data entered on 01-01-14
    Cell A2 has data entered on 02-02-14
    Cell A3 has data entered on 03-03-14

    Cell B1 has data entered on 01-15-14: When this happens, I would like Cell C1 to read 01-01-14
    Cell B2 has data entered on 02-21-14: When this happens, I would like Cell C2 to read 02-02-14
    Cell B3 has data entered on 04-09-14: When this happens, I would like Cell C3 to read 03-03-14

    Thanks again for all the help!!!

  6. #6
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Enter the Date when data was originally entered into another cell

    Hi, Hood,

    maybe use a cellīs comment to store the date and copy that if needed:
    Please Login or Register  to view this content.
    Code will work for only one cell in Column A at a time.

    Sample from nathansev may look like (please mind that there must exist a sheet with the name AUDIT in the workbook):
    Please Login or Register  to view this content.
    Ciao,
    Holger

  7. #7
    Forum Contributor
    Join Date
    09-25-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    152

    Re: Enter the Date when data was originally entered into another cell

    Thanks!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Table: Auto add new row: How can I modify the formula originally entered in a cell?
    By brucemc777 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-10-2014, 04:34 PM
  2. When a date entered on a specific cell, automatically enter a text in other cell
    By mmccra2858 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2012, 09:57 AM
  3. Enter and Lock Current date when a number is entered into another cell
    By Banyonb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2012, 04:54 PM
  4. Replies: 3
    Last Post: 05-28-2008, 01:32 PM
  5. can excel automatically enter the date data in a cell was entered
    By mg_sv_r in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2006, 06:30 AM

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