Annually we have to inventory capital purchases. The idea is to ensure items purchased (over $1000) are not missing, but also allows us to put an eye on the items in case they need to be replaced or discarded. Each item has a unique barcode on them. What I would like to do, if possible, is once a barcode is scanned, have a form appear with the condition, date, inventoried by, comments. This then would place the info on a different sheet that refs the main list of items. Is something like this possible? Hope this makes sense!
LinkedIn
Twitter
