I have a worksheet for formation evaluation that automatically inputs the "Top depth" based on the "bottom depth" of the previous formation. However, there are instances where the top depth needs to be manually entered, thus deleting the formula. I would like to keep this flexibility, but have it so the initial formula is retained and automatically input if the manual entry is deleted or the spreadsheet is used for another evaluation. Obviously I could just delete and scroll the formula above it down to cover, but I believe there is a way to write a VBA code to ID the event change and repopulate the deleted cell with the formula. Is this possible?