+ Reply to Thread
Results 1 to 2 of 2

Automated static timestamp WITHOUT Macros (Long shot maybe?)

  1. #1
    Registered User
    Join Date
    03-28-2023
    Location
    Cardiff, UK
    MS-Off Ver
    MS365 Version 2403
    Posts
    8

    Lightbulb Automated static timestamp WITHOUT Macros (Long shot maybe?)

    Hello,

    My spreadsheet exists as a single-use calculator workbook on an online documentation system. Users are required to download a fresh copy from the system every time they use it and it and paste their data into it, but sometimes they will re-use a previously downloaded copy by deleting the old data and pasting in the new data. This increases the risk of errors and I want to try and discourage this without the use of macros, because of time constraints (I know this can easily be done with a simple macro but I have a deadline to validate the spreadsheet by and the use of any macros requires extra validation steps, which are time consuming).

    I realise this is a long shot but can anyone think of a way this could be prevented or at least traced, without the use of macros? Just anything which could indicate when the spreadsheet was downloaded, or when data was first pasted in, so I can run a quick check to make sure that a fresh version was used.

    I've included a sample of the spreadsheet anyways but some info here: the data which users paste is in a very predictable fomat, so certain cells will always be blank and certain cells will always contain "1", for example. The spreadsheet actually does not perform its calculations unless all these conditions are met, as this indicates that the data has been copied/pasted incorrectly. Also the entire spreadseet apart from the yellow data entry regions will be locked for editing by users.

    P.S. if it's not possible without macros and you are able to, please provide the macro which you would use to achieve this, so I can at least present options and try and wangle a deadline extension if needed!

    Thanks in advance!

    Phoebe
    Attached Files Attached Files

  2. #2
    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
    44,063

    Re: Automated static timestamp WITHOUT Macros (Long shot maybe?)

    Messy without VBA, I think.

    1. Enable iterative calculations.

    2. In D1:

    =IF(C6="","",IF(D1="",NOW(),D1))

    the datestampl will reamin until the value in C6 is deleted, or overtyped.

    Is that anywhere close?
    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

+ 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. Static timestamp using check box
    By dddavedg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-12-2016, 05:45 AM
  2. Static date and timestamp
    By robvilla in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2016, 05:30 PM
  3. Charts formatting--long shot
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-22-2013, 07:57 PM
  4. [SOLVED] Static Timestamp Between Sheets
    By Randomhero180 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2012, 10:54 AM
  5. static timestamp that updates using vba code
    By xenador in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2007, 02:56 AM
  6. Long Shot: Competition Draws with Excel
    By kebabking in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2006, 03:13 PM

Tags for this Thread

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