+ Reply to Thread
Results 1 to 3 of 3

DATE/TIME Stamp based on last entry in range of cells

  1. 06-10-2020, 08:33 AM #1
    johnmitch38
    johnmitch38 is offline
    Forum Contributor
    Join Date
    05-29-2009
    Location
    sheffield
    MS-Off Ver
    Excel 2013
    Posts
    210

    DATE/TIME Stamp based on last entry in range of cells

    On the attached, I want to record a date/time stamp in column F based on the date/time the last entry was recorded in the range of cells H:AA.

    i.e. if I manually type 95 in cell X2 today, I want F2 to say 10/06/2020
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-10-2020, 08:43 AM #2
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: DATE/TIME Stamp based on last entry in range of cells

    maybe so (in Sheet1 module)
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 06-10-2020, 08:58 AM #3
    johnmitch38
    johnmitch38 is offline
    Forum Contributor
    Join Date
    05-29-2009
    Location
    sheffield
    MS-Off Ver
    Excel 2013
    Posts
    210

    Re: DATE/TIME Stamp based on last entry in range of cells

    Perfect - much appreciated, thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time and date stamp of dynamic cell plus look up for last entry of the month.
    By Samboco in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-12-2019, 01:38 PM
  2. Need to populate select cells onto another page if date stamp falls in a time range.
    By joplrw10 in forum Excel General
    Replies: 5
    Last Post: 03-02-2015, 05:57 PM
  3. Static Date Time stamp for cell entry that doesn't require changing iterative setting
    By sharrington in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 04:14 PM
  4. How do I lock a stamp date/time formula for an entry on a row?
    By PROPERTIES INC. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-09-2012, 01:24 PM
  5. Date and Time Stamp for Last Activity in Range
    By XLevel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2011, 07:34 AM
  6. I need a date/time stamp for cell entry
    By kAustin79 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-26-2007, 11:26 AM
  7. date time stamp excel activity log entry?
    By Skullcramp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2005, 06:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1