Counting Colours in Excel
 

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?

Counting Colours in Excel
 

.. I highlight in the appropriate colour - one colour for returned on
time, one colour for returned late, another colour for cancelled.

One thought is to use a col instead for "Status", data-validated with a
simple list for standard text, eg: On Time, Late, Cancelled

Then you could easily use autofilter, pivot tables, etc to track/analyse it
downstream. And if you need visual distinctions, just use CF to color it to
taste by pointing to the 3 values in this "Status" col
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Carla" wrote:
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?

Counting Colours in Excel
 

Visit Chip site at www.cpearson.com . He has VBA code to count by colour.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Carla" wrote in message
...
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?