+ Reply to Thread
Results 1 to 3 of 3

Restoring Formula after Deleting Text

  1. #1
    Registered User
    Join Date
    06-09-2020
    Location
    Earth, North America, USA
    MS-Off Ver
    2016
    Posts
    5

    Restoring Formula after Deleting Text

    I have a spreadsheet in which several fields are calculated field, they take a date and add X number of days based on the task SLA. This is to auto calculate where we are in the project. However I want the user to be able to enter in the actual date the task took place, and the other fields will auto update. However if the user were to accidently enter a date into the field, and needs to delete it, I would like to have the formula restored so the auto calculations can continue. Is this possible?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Restoring Formula after Deleting Text

    Is this possible?
    Not without VBA.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Restoring Formula after Deleting Text

    Please change your location to something meaningful.

+ 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. replacing text in a cell without deleting formula
    By keymaster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2020, 08:46 PM
  2. Restoring decimal place to cells with text & sum?
    By Emma Frost in forum Excel General
    Replies: 1
    Last Post: 06-30-2015, 04:56 PM
  3. [SOLVED] Formula for Deleting Text based on Criteria
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-01-2015, 11:59 PM
  4. Formula for Deleting Text based on Criteria
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-31-2015, 04:00 PM
  5. Formula for Deleting Text based on Criteria
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-31-2015, 02:08 AM
  6. Formula for deleting duplicate text entries
    By rhebus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2012, 01:16 PM
  7. Restoring original formula by VBA
    By 1eyedjack in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-21-2010, 05:43 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1