+ Reply to Thread
Results 1 to 1 of 1

Inventory counting by comparing stock barcodes against master barcodes list

  1. #1
    Registered User
    Join Date
    03-23-2011
    Location
    glasgow, scotland
    MS-Off Ver
    Excel 2007
    Posts
    3

    Inventory counting by comparing stock barcodes against master barcodes list

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1