+ Reply to Thread
Results 1 to 2 of 2

Time stamp when a row is complete but updates everytime something is input to other cells

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Iowa City, Iowa
    MS-Off Ver
    Excel 2007
    Posts
    1

    Time stamp when a row is complete but updates everytime something is input to other cells

    Hello,
    So I am trying to create a timestamp code that will fill in the exact time an entire row is completed. So far the code I have come up with works for the 1st row but then any subsequent rows update all the timestamps.
    Here is an example of my formula:

    =IF(AND(NOT(ISBLANK($D$14)), NOT(ISBLANK($F$14)), NOT(ISBLANK($G$14)), NOT(ISBLANK($H$14)), NOT(ISBLANK($J$14)), NOT(ISBLANK($K$14))), NOW(), "")

    Formulas change for each row, for example: for B15 all would be 15, B16 all would be 16 etc.

    Time stamps should be in cells B14 through B23 and each should represent the time each of these rows (14-23) are completed but not update all timestamps.

    excel scan 1st row.pngexcel scan 2-3rd rows.png

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Time stamp when a row is complete but updates everytime something is input to other ce

    Excel does not have a Function that timestamps. I'd suggest using VBA.

    Assuming that, like your example, only numbers are entered between D and K 14;
    Right click on the sheet tab and "View Code"
    Paste this code into the VBA Editor which opens up and then close it
    Please Login or Register  to view this content.
    See if that works for you. You'll need to save your file as an xls or xlsm.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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