Hi all..new here and also new with excel code.
We have +-100 power tools which we lend to students/apprentices and we would like to keep track of these tools.
We have a barcode generator/printer and using excel 2010.
We have setup an excel spreadsheet with the scanned barcodes of the tools in column A.
What we are trying to achieve is:
When a tool is lent out, we scan it and in excel it should lookup the barcode and in the respective row in column B (Outgoing Stock) it should print the date.
When the tool is returned it would be scanned again and the date should be printer in the respective row (In Stock) column C.
Is this at all possible?
Thank you in advance
Gb