I have a workbook containing about 40 sheets for each employee. Within
each sheet, there is a chart such as this:
date------------- training 1----training 2------training 3 ...........
??/??/????-------------X
??/??/????---------------------------------------X
??/??/????-------------X
.........
I need to automate a process which will scan a sheet (I -don't mind-
running a macro on each sheet manually) and will retrieve training that
the employee DOES NOT yet have, and input it in some sort of chart
format.
In other words, from the above example, training 2 has not be done by
the employee, and so the outputted chart will show me the employee name
(or the sheet name) and the training that they have to complete.
Thank you!
--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile:
http://www.excelforum.com/member.php...o&userid=36709
View this thread:
http://www.excelforum.com/showthread...hreadid=564892