I work in sales analysis and use files that have many many pages with
lots of information and formulas. Is there a method either in VB or in
data validation for me to check that I have done a petty but
meaningful task that I may have missed? For example, if I am ranking
areas by their total achieved sales and then when I update these with
new data the formulas cause the areas to move around and become un-
ranked... is there a method for Excel to remind me that I need to sort
them by rank again before I close the file?? Or similarly another
petty example is for Excel to remind me to change a piece of text
depending on the day of the week.
This would ensure accuracy and aid myself in cutting down the time it
takes to check the reports that I send out thus making my life easier
by not missing these things which are sometimes too impossible to spot
as you've been looking at spreadsheets for hours on end!!!

Any help is really appreciated, I just hope you understand what I'm
talking about.

Regards

Lucas