Forum Discussion
Real key management using excel
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 ...
so i'm having an issue. the hard keys inventory has suite #s and when appropriate room#s. The log correspondingly uses a specific suite/room number (i.e. 201 is suite key while 201A is room) and then the ALL tab only lists 'rooms' (i.e. 201A and 201B but NOT suite 201). So you want a name to get pulled from this ALL tab but if you enter 201 will it bring up 201A or 201B name? furthermore, you want the column L on the ALL tab to look up the keys checked out for BOTH suite and room but how do you know if 201A or 201B checked out that 201 suite key....
i updated the formula to display NO or Y 1 or Y 2 or ... but that is only effective on the specific room #s due to the problem above.
i updated the formula to display NO or Y 1 or Y 2 or ... but that is only effective on the specific room #s due to the problem above.
m_tarler,
Matt, just a thought but do not know if it plausible. using a formula, is there a way, when only a suite# is entered, for pop up window, like a message box, to appear prompting for selection of Room A or B, to select which occupant is checking out the suite key? This of course only to happen when there are rooms A or B involved. Not needed for rooms that don't have A or B within.
Matt, just a thought but do not know if it plausible. using a formula, is there a way, when only a suite# is entered, for pop up window, like a message box, to appear prompting for selection of Room A or B, to select which occupant is checking out the suite key? This of course only to happen when there are rooms A or B involved. Not needed for rooms that don't have A or B within.