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?