Hi,
I have a brand X which has a total of say 100 items all with a unique bar code. I have just received a delivery from the supplier of brand X and have used my phone barcode scanner to get a list of the barcodes from the products we received.
I want to compare the list of barcodes I have against the master list of barcodes and see how many and what of each product I have received.
I found a program where using a macro I could input each code and get an inventory count, however I want to be able to upload/paste my whole stock take list and see my inventory count.
Does anyone have any ideas? I have attached my workbook.
Hope that someone can help, not used excel like this since my Masters degree days....and that still hasn't helped!!
I would really appreciate if someone had a workbook that was similar to what I need so I can work from that. I am not the best at programming.
Bookmarks