I need to do inventory using a barcode scanner and excel. How do I make it so after I scan it the program will search the old inventory spreadsheet for the matching barcode and copy the barcode as well as the adjacent cells (with the item names and serial numbers) into the new spreadsheet.
I am looking for some help for creating an inventory database.
Basically what I want to achieve is:
- when bringing new items in the inventory: I will print barcode stickers and stick them on each new item brought in (on every item different barcode even if items are the same)...
I want to a sheet for control my inventory of not more then 100 items.
If you have any sheet or URL (On which i can download sheet) then please tell me as early as possible.
M Anas raza
+92 342 7652600