Results 1 to 2 of 2

Stop today function from updating daily

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2015
    Location
    Texas
    MS-Off Ver
    Microsoft Office 2010
    Posts
    7

    Stop today function from updating daily

    Hello Forum!

    I have the attached spreadsheet where I enter the status of COMPLETE in a certain cell (multiple columns). In the column just right of that the date auto populates depending on when the information was entered. If I come back to the spreadsheet a few days later, THAT CURRENT date is there. I am looking for a way to freeze the dates once populated. I do not want them updating daily. Would someone be able to help me with this? I am using the TODAY() function to auto populate the date, but am pretty certain that the freeze fix will come by way of VBA coding (macro). Any suggestions would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Moving data daily to a different column with the today function possible?
    By darthorious in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-09-2015, 03:51 PM
  2. Please help me with VBA code to stop data updating using today's date.
    By Vickymabo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2015, 05:54 PM
  3. Looking for VBA code to stop data updating using today's date.
    By Vickymabo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2015, 02:34 PM
  4. Looking for VBA code to stop data updating using today's date.
    By Vickymabo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2015, 02:30 PM
  5. Stop today function calculating
    By excelstacy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-22-2013, 05:39 PM
  6. Help with automatic chart updating/auto updating today function
    By Tux2424 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 04:45 PM
  7. [SOLVED] How do I stop today() from updating date on saved spreadsheets?
    By lionmark in forum Excel General
    Replies: 2
    Last Post: 01-03-2005, 09:06 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