Excel automated validation!?!?

L

Luke.Reader

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
 
D

Debra Dalgleish

For some tasks, maybe you just need a list of procedures that you follow
when updating a file.
For other things, such as text dependent on weekday, you could create a
table of options, and use a lookup formula to return the appropriate
text, instead of manually changing it.
 
Top