Hello,

I'm not very experienced with excel and I haven't been able to come up with any answers via the search. I work in a hospital and we collect equipment daily that we process for cleaning and service. My problem is I need to be able to have an employee come in from collecting and scan their barcode that we have on the wall. This will fill column A. Next they need to scan the product type that they have collected throughout the hospital filling column B. In column C we would like all the serial numbers of equipment they have gathered for service. This would go down for however many pieces of equipment they have. After they are done, I'd like for them to be able to scan a barcode to send the fill area back to the A column for another employee. Any help provided would be appreciated and I thank everyone in advance for their time.

Chuck

Sample.xlsx