Auto updating of excel sheet ?

Latest Any Answers

I have an excel sheet which contains work carried out that also requires reviewing. Once approved initials are placed say in cell A20 in a box and will always appear at the same place on all sheets.

Is there any way to ensure that if the sheet is altered at all then the initials in cell A20 wil be erased thereby indicating the sheet had to be re-reviewed ? (the cell would need to be protected to prevent reviewers initials being entered by anyone else)

The sheet is not a fixed template and contents will vary. Header will be the same however for each client and review initials will always be in same cell. Idea is that once reviewed and signed any subsequent changes to sheet take out the initials so if reprinted it is clear that this version has not been reviewed. Thanks for the response.