I work in a large manufacturing facility that has tool drawers and shadow boards everywhere. Even with these drawers and boards, we still lose or misplace tools all of the time. I would like to set up an excel sheet that will allow us to scan tools out as we use them, then scan them back in when they are returned to ensure tools are where they belong. My idea was to assign each employee a barcode so that they first scan their assigned barcode then scan a barcode on the tool to check it out. The process would be the same for when the tool is returned. I would like to see a running inventory of the tools as well as who the tool was checked out by and at what time/date. I know this is a lot and most of us here are not excel savy. Can anyone give me some guidance on how to make this work?
Bookmarks