+ Reply to Thread
Results 1 to 3 of 3

Guidance with Barcode Scanned Sales Recon Macro

  1. #1
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Guidance with Barcode Scanned Sales Recon Macro

    Hi All

    A little out of my depth here...First time I am working with Barcodes /Scanners.
    Have attached a sample file. Scenario is as follows:
    Client receives 4 Bags with barcode stubs...Representing sales for 4 cost center's.
    Via scanner, each bag's stubs is scanned in on Sheets("SalesScan"). Can be up to 1000 scanned items per cost center.
    I have written code that counts occurrences of each barcode and places it into the sales column (Col N) of each individual cost center represented by the 4 sheets...My query though is...Is there an easier way for this process to take place. Would appreciate any feedback regarding the barcode/sales scenario.
    Code below...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 09-05-2017 at 12:53 PM. Reason: Edited Title
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Guidance with Barcode Scanned Sales Recon Macro

    Hello sintek,

    Capturing data of such nature has been, and will always be a long laborious and tedious task, whether it is done manually or by scanning. Like taking stock counts or running daily perpetual stock checks. Each item has to be accounted for, and I honestly believe that you have reached the point of diminishing return as far as speeding up the process.

    Groete, Mater.

    W.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Information regarding Barcode scanning and vba

    Hi Winon

    Hey there my friend...All Good I'm guessing. Thanks for input. I have tested with 4000 plus scans per cost center and the code is instantaneous...
    My thoughts however and the reason for this post....Is this the only way that one could achieve the result....Must each stub be scanned into a specific column by selecting the sheet etc etc etc etc and then a command button pressed to action the result....No way of selecting the sheet from a drop down and code doing the rest...Once again I'm working with UserForms ...A Retail POS... So trying to gauge the possible options via Barcode scanner. Have searched web and all I could find to this effect is a spreadsheet that one clicks on start cell and then every time a stub is scanned it puts the code into the activecell then moves down the rows each time per scan....


    Edit....So basically, how would I allow scanning to be inputted into a textbox into the sheet and then have my code do the rest...
    I don't want the user to select sheet and select cell to scan.
    Last edited by sintek; 09-06-2017 at 01:44 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 08-24-2022, 12:27 AM
  2. [SOLVED] separate scanned barcode data into different textboxes in userform
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2017, 10:54 PM
  3. Barcodes sometimes cant be bleeped/scanned using barcode gun
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2015, 09:09 AM
  4. Update spreadsheet when a barcode is scanned
    By fuzzyexcel in forum Excel General
    Replies: 0
    Last Post: 11-06-2014, 04:51 PM
  5. Need to copy 9 cells to another worksheet when barcode is scanned
    By MOMO7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2014, 05:00 AM
  6. Adding Date in Column When Barcode is Scanned
    By zwarner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2013, 10:59 PM
  7. Switch worksheet depending on barcode scanned?
    By Mattneedshelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2013, 06:06 AM

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