+ Reply to Thread
Results 1 to 11 of 11

If initials are generated in a cell then a permanent date stamp is generated

  1. #1
    Registered User
    Join Date
    10-08-2016
    Location
    Florida, United States
    MS-Off Ver
    2010
    Posts
    14

    If initials are generated in a cell then a permanent date stamp is generated

    Good afternoon everyone,

    I keep a running with multiple users entering data in the log. I am looking to find the bottle necks in our process based on the date someone initials the log.

    I5 is beginning line of data.

    When intials are typed into I5, I want a permanent date stamp in G5.

    I have found solutions for this EXCEPT it only generates in one specific cell. I need this to generate all the way down the sheet

    I5 - G5
    I6 - G6
    I7 - G7

    And so fourth.

    Any suggestions would be appreciated.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: If initials are generated in a cell then a permanent date stamp is generated

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter an ID in column I.
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: If initials are generated in a cell then a permanent date stamp is generated

    Try this out.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: If initials are generated in a cell then a permanent date stamp is generated

    My PC threw a hissy fit and posted my file before I'd finished. No code needed in my offering. All you need to do is enable iterative calculations and use the formulae in the shaded cells in column G:
    =IF(I5="","",IF(G5="",NOW(),G5))

    copied down. To enable iterative calculations: FILE/OPTIONS/FORMULAS and check the enabling box.

  5. #5
    Registered User
    Join Date
    10-08-2016
    Location
    Florida, United States
    MS-Off Ver
    2010
    Posts
    14

    Re: If initials are generated in a cell then a permanent date stamp is generated

    Works perfectly. Thank you so much for the help guys!

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: If initials are generated in a cell then a permanent date stamp is generated

    Glad to help.

  7. #7
    Registered User
    Join Date
    10-08-2016
    Location
    Florida, United States
    MS-Off Ver
    2010
    Posts
    14

    Re: If initials are generated in a cell then a permanent date stamp is generated

    Mumps,

    I am a real VBA noob, if I wanted to duplicate that same formula for say E and F, how would i format the string? It doesnt like copy/paste

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: If initials are generated in a cell then a permanent date stamp is generated

    Do you mean that you want to enter an ID in column F and you want to date stamp in column E?

  9. #9
    Registered User
    Join Date
    10-08-2016
    Location
    Florida, United States
    MS-Off Ver
    2010
    Posts
    14

    Re: If initials are generated in a cell then a permanent date stamp is generated

    Yes, I will need this formula about 10 times (different columns) to watch every step in the process.

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: If initials are generated in a cell then a permanent date stamp is generated

    Have you tried the formula that I suggested. It's infinitely adaptable.

  11. #11
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: If initials are generated in a cell then a permanent date stamp is generated

    I would need to know exactly which columns are involved. It is always easier to help and test possible solutions if we could work with your actual file. Perhaps you could post a copy of your file. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.

+ 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. Permanent Date Stamp Macro
    By basmster in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-04-2016, 03:15 PM
  2. [SOLVED] vba not identifying date that is generated by a formula question
    By lilsnoop in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-29-2015, 12:01 AM
  3. Permanent date stamp based on IF statement outcome
    By Darren6177 in forum Excel General
    Replies: 7
    Last Post: 05-09-2014, 04:30 PM
  4. Insert permanent Date & Time stamp if & when another cell is populated
    By valentino1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 10:15 AM
  5. [SOLVED] Insert permanent Date & Time stamp if & when another cell is populated
    By David_S_Walker in forum Excel General
    Replies: 6
    Last Post: 03-12-2014, 06:08 AM
  6. [SOLVED] Insert permanent Date & Time stamp if & when another cell is populated
    By BASELOO in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2012, 02:27 PM
  7. Enter data into a cell have comment generated with the current date and time
    By soulfriend in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2011, 04:06 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