+ Reply to Thread
Results 1 to 9 of 9

Excel 2007 : Barcode Inventory Sheet

  1. #1
    Registered User
    Join Date
    08-14-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Barcode Inventory Sheet

    I am looking for help with a workbook to keep a basic inventory list.

    What I would like is to be able to use my scanner to scan an item into and out of stock, possibly by using a Userform or something similar.

    I want a basic workbook inventory that has the usual things...barcode, item number, item name, quantity

    When I sell an item I just want to scan it as I pack it and it takes it off my sheets or when I get stock in, I scan an item and it adds it to my sheets.

    Over time I would like it to grow to be able to show whats sold on each product, when it was sold, and so on.

    Any help would be very grateful indeed.

  2. #2
    Registered User
    Join Date
    08-14-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Barcode Inventory Sheet

    Bump!! Bump!!!

  3. #3
    Registered User
    Join Date
    11-12-2009
    Location
    United States
    MS-Off Ver
    Excel 2010 (or Excel 2003)
    Posts
    24

    Re: Barcode Inventory Sheet

    Quote Originally Posted by bigstef View Post
    Bump!! Bump!!!
    Search BARCODE INVENTORY -- see the thread I started. If you want an updated version, I've got it pretty functional now (standalone).

  4. #4
    Registered User
    Join Date
    08-14-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Barcode Inventory Sheet

    Cant see the post you are talking about. Searched for your sheet but found this one instead now.
    http://taltech.com/files/Inventory.exe

    Just need a bit of help to do one quite important thing with the sheet.

    When adding 1 item to stock, you scan the barcode then press done and it adds one to stock. Or if you prefer it can also take one off stock by the same process, scan the barcode then press done.

    What I need to do with this sheet is when I choose to scan my inventory I would scan the barcode, but instead of pressing done I would prefer the sheet to add one to stock automatically then clear the input box ready for me to scan the next item. That way when doing an inventory stock check I just need to keep scanning products to add them to my stocks sheet.

    I am sure this should be easy for all the experts here but I just havent got a clue how to amend this sheet to do this.

    Any help is very much appreciated.
    Thanks, Steve

  5. #5
    Registered User
    Join Date
    08-14-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Barcode Inventory Sheet

    Bump

    Any help with this please.

  6. #6
    Registered User
    Join Date
    08-14-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Unhappy Re: Barcode Inventory Sheet

    Bump again.....

  7. #7
    Registered User
    Join Date
    08-14-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Barcode Inventory Sheet

    Another week another bump!!!

  8. #8
    Registered User
    Join Date
    08-14-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Barcode Inventory Sheet

    Guess what???


    Bump

  9. #9
    Registered User
    Join Date
    08-14-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Barcode Inventory Sheet

    Forget it.
    Not very good at all guys.

+ 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