I currently have a workbook that I add a new worksheet to each week.  I am
trying to track work orders - how many, if they are returned within a
suitable time frame and if work gets cancelled. My system right now is pretty
basic - download list from our database onto an excel spreadsheet which is
added to the main workbook.  As the paper copies of the work orders are
returned, I highlight in the appropriate colour - one colour for returned on
time, one colour for returned late, another colour for cancelled.  I want to
be able to calculate a percentage if work orders returned on time.  I would
also like to sort them if at all possible, so that the ones that aren't
coloured (not returned yet) are all together.  Am I able to do this from this
system that I currently use?  If not, does anyone have any better suggestions
that don't involve knowledge of programming?