+ Reply to Thread
Results 1 to 2 of 2

Stop today function from updating daily

  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

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Stop today function from updating daily

    Hello. This is a pretty standard thing to want to do. The below macro will recognize anytime you select Complete in column N and will put todays date is column O at that row. The date will be static. The code goes in the visual basic editor under the applicable sheet code module. Let me know if you have any questions.

    Please Login or Register  to view this content.
    EDIT: I just noticed that you might need this for multiple columns. If that is the case let me know which columns

    EDIT2: this should cover all your columns as you have them represented (even columns)

    Please Login or Register  to view this content.
    Last edited by stnkynts; 12-18-2015 at 01:57 PM.
    If you are happy with my response please click the * in the lower left of my post.

+ 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. 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. 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