My boss has lately given me a new project an absence report for human
resources. It has 8 categories (sick, personal, vacation, funeral
leave, professional leave, jury duty, a.w.o.l., and worker's comp)
thereare 70 employees and each has to be recorded each day. (mon-fri).

Now that there's the background. Is there a way to give a letter a
value? Say I enter V for vacation can I get the program to recognize
it as a value of 1 then have all the v's total elsewhere? Sorry if
that's confusing, but if anyone has any ideas, it would be much
appreciated.

DarklyConfused


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949
View this thread: http://www.excelforum.com/showthread...hreadid=557354