+ Reply to Thread
Results 1 to 11 of 11

Auto date stamp when data in adhjacent cell

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    Florida. USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Auto date stamp when data in adhjacent cell

    Brand new here so thank you in advance for assisting with my ignorance :-)

    I have a woorkbook with monthly worksheets. I need the cells in column A to auto fill a date or date and time stamp when there is data entered in the adjacent B cell. The range is A4 to A250. I need to make sure the date does not change once the B cell is used. The sheet is used for the month so at the end of the month there would be a range of dates indicating the date the data was entered.

    Thank you,
    Dean

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Auto date stamp when data in adhjacent cell

    Put this into the code module of the relevant worksheets :-

    Please Login or Register  to view this content.
    Elegant Simplicity............. Not Always

  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: Auto date stamp when data in adhjacent cell

    Hi, Dean,

    from what I read from your opening post:
    Please Login or Register  to view this content.
    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
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Auto date stamp when data in adhjacent cell

    Right click on your sheet name at the bottom of excel and paste this code into the window that opens.

    Close the window and enter data into column B.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    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: Auto date stamp when data in adhjacent cell

    Hi, mehmetcik,

    I need to make sure the date does not change once the B cell is used.
    Column A will be altered by your code on any change in Column B.

    Ciao,
    Holger

  6. #6
    Registered User
    Join Date
    12-04-2013
    Location
    Florida. USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Auto date stamp when data in adhjacent cell

    Mehmetcik - Thank you! That works perfectly!! Is there a way to apply that to the entire workbook, besides entering it on each sheet?

    Thank you again

  7. #7
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Auto date stamp when data in adhjacent cell

    Hi danield

    I'm afraid not.

    some code must be in every worksheet.

  8. #8
    Registered User
    Join Date
    12-04-2013
    Location
    Florida. USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Auto date stamp when data in adhjacent cell

    Thank you to Holger and Andy as well.

  9. #9
    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: Auto date stamp when data in adhjacent cell

    Hi, Danield357,

    the solution you praise is not what you have asked for in the opening post!

    Ciao,
    Holger

  10. #10
    Registered User
    Join Date
    12-04-2013
    Location
    Florida. USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Auto date stamp when data in adhjacent cell

    No problem, way better off than i was! :-)

  11. #11
    Registered User
    Join Date
    12-04-2013
    Location
    Florida. USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Auto date stamp when data in adhjacent cell

    Holger, I was getting an error with one of the other codes provided, Mehmetcik's code is providing the function i was looking for. I triied it before i had time to post the error info. I am sure it was something iwas doing wrong on this end.

    Thanks to all again :-)

+ 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. Replies: 4
    Last Post: 02-11-2013, 07:35 PM
  2. Auto Date Stamp Column A when data in Column B
    By medihx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2011, 06:56 PM
  3. Auto Sort, Auto Lock, Auto Date & Time Stamp
    By suehatesyou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2010, 02:57 PM
  4. Auto date stamp
    By gavster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2008, 01:59 AM
  5. Auto date and time stamp
    By Nunzio in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2008, 09:54 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