I have a monthly table listing all employees names (rows) and days of month
(columns). I would like to be able to enter an alpha character, like "v" for
vacation in the date column and have the number hours assigned to that letter
deduct from the total number entered into the total for that person. I think
I need a Lookup table and assignment to a range to make this happen, but
would like some suggestions on exactly what the programming should be.
Thanks!