Hello Excel Family. I am a manager of 168 Dorm rooms for which I’d like to create an inventory & check out for hard door keys.  I’d like to be able to have an inventory of keys on key tags with keys and be able to check out a key or keys as necessary.  I have main door keys and keys that fit room A & B room doors.  So that means there is a main door and 2 bedroom doors with a suit with separate keys.  There are main door keys that only work on the main doors and then there are individual room door keys that open the main entry door and the assigned bedroom door.  I need to be able check a hard door key out which in turn reduces the available on hand inventory but also knows a key or keys are checked out.  Does anyone know of something already working that could be altered if necessary to fit my needs?

Carl

​Hello Excel Family. I am a manager of 168 Dorm rooms for which I’d like to create an inventory & check out for hard door keys.  I’d like to be able to have an inventory of keys on key tags with keys and be able to check out a key or keys as necessary.  I have main door keys and keys that fit room A & B room doors.  So that means there is a main door and 2 bedroom doors with a suit with separate keys.  There are main door keys that only work on the main doors and then there are individual room door keys that open the main entry door and the assigned bedroom door.  I need to be able check a hard door key out which in turn reduces the available on hand inventory but also knows a key or keys are checked out.  Does anyone know of something already working that could be altered if necessary to fit my needs? Carl  Read More

​