Equipment Check In/Out Help!!

Hi All!

I need some help! I'm trying to setup a barcode excel sheet to check in/out the RF guns that associates use each day. I have it so you can input their badge then it automatically inputs their name, department, and time checked out, then you can double click the time in and the cell is filled in. I have the tabs setup on a Mon thru Friday basis. What I need help on is when you sign out equipment the following day, I need it to recognize if that piece of equipment is available or if it's was not scanned back in thus making it not available.

Hope I wrote this clear enough. I have attached what I'm working on. Just the first 2 tabs are formatted (Mon, Tues).

Thanks in advance for your help!!!Equip Check.xlsm

The sheet may be protected, if so the password is hulk2008...Thanks again

No one can help me on this?