Help with Matrix

[Les Stout]

Hi all, i have a training matrix from 2005 that i have a summary page
for. I have approx 95 different courses which are listed down in column
"A" and across the top i have all the employees by name and Co ID No.
+/- 25 of them.
I also have different colors. In the cells is either the number of hours
the course was, which has priority and then i have red for "Required but
not planned", Yellow for "required and planned" and "green" for
completed.
I need to scan through the variouse sheets for the years and report on
the summary the result.

Any help and advise would be most welcome.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

[Bob Phillips]

I think this might help
http://www.xldynamic.com/source/xld.ColourCounter.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Les Stout" <[email protected]> wrote in message
news:[email protected]...
> Hi all, i have a training matrix from 2005 that i have a summary page
> for. I have approx 95 different courses which are listed down in column
> "A" and across the top i have all the employees by name and Co ID No.
> +/- 25 of them.
> I also have different colors. In the cells is either the number of hours
> the course was, which has priority and then i have red for "Required but
> not planned", Yellow for "required and planned" and "green" for
> completed.
> I need to scan through the variouse sheets for the years and report on
> the summary the result.
>
> Any help and advise would be most welcome.
>
> Les Stout
>
> *** Sent via Developersdex http://www.developersdex.com ***

[Les Stout]

Thanks will have a look.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***