I have a spreadsheet containing several worksheets. In one worksheet called Costs, I copy some information to another worksheet called Status. Status can have information directly entered into it as well as copied from Costs.
When a row in Status has a cell changed to Completed, an email is generated and the row is then deleted. The Costs worksheet is reconciled every month and completed entries are copied to a separate archive spreadsheet and then deleted from the Costs worksheet.
Would it be possible to record in the Costs worksheet, the date when the corresponding entry in the Status worksheet is deleted? Unfortunately, macros cannot be used.