Forum Discussion

Carl_61's avatar
Carl_61
Iron Contributor
Jul 13, 2024

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 ...
excel
Formulas and Functions
Carl_61's avatar
Carl_61
Iron Contributor
Jul 19, 2024
Thank you as always Matt. This appears to be working perfectly.
  • Carl_61's avatar
    Carl_61
    Iron Contributor
    Jul 20, 2024

    Carl_61 

     

    Matt, there are 2 other things, if possible, I'd like to accomplish with the key inventory. On the attached, you will see an ALL Tab. On this Tab you will see column "K", Storage Locker. As you look down the column you will see a "Y" with a number, ie., "Y 1", "Y 2" or "Y 3". These codes represent "Yes" this individual has a Storage Unit. The number represents how many Storage Units. I'd like to if possible, do the same in column "L". A quick glance to see if this individual has a hard key and if so, How Many. Also, is there a way to add to Key Log, the name of the individual, associated with the room entered in column "B" to be displayed in column "E". The name being pulled from the ALL Tab for the room entered in column "B" on the Key Log.

    Thank you Matt.

Resources