Automatic update of Inventory using barcode input...

[thumper300zx]

I run a small business. I want to start keeping track of inventory using a barcode system.

I know Excel "ok", but I don't know programming.'

I'd like to be able to do something very simple (for now)...

For example...if I had PRODUCT / CODE / INV VALUE

A - CODE A - 5
B - CODE B - 11
C - CODE C - 14

I would want to be able to click a button (or scan a code for) : ADD +1 or REMOVE -1

...then scan the barcode on the product (A) and have it add or remove one, respectively. So, if the row for A is:

A - CODE A - 5

I choose "ADD" (with a button or scan code), then scan the barcode, and the spreadsheet automatically finds the code in the sheet, and changes the corresponding inventory value:

A - CODE A - 6

Does that make sense? How might I go about doing that?

[mrice]

Please see the attachment.

You will find the main code by hitting Alt F11. The code relating to the buttons can be seen by hitting F7 wher the userform is displayed in the VBA editor.

[thumper300zx]

Please see the attachment.

You will find the main code by hitting Alt F11. The code relating to the buttons can be seen by hitting F7 wher the userform is displayed in the VBA editor.

Absolutely perfect! Thanks. I will review the code and learn what's going on.

You are a gentleman and a scholar!!!!

[thumper300zx]

n/m (10 char)

[feivele]

i want to use this book1 but my barcode scanner will input upc string in textbox and then click enter, this worksheet dosent accept this. i would like to know how, or perhaps u could do it, to have the scan box stay open and simply run the code when enter is pressed, then the textbox cleared and we start over.....could you help me?

[feivele]

so i got it working acording to what i asked...or so i think


not all the product upc codes work...only many of them....

why do you think not all of them work?

i havent a clue

[KilluhAnt]

Hey guys I'm not much of an excel user so I'm having a bit of trouble with using these pre-made excel sheets, every time I scan I get a pop up message saying "CODE NOT FOUND" can you please help me out with this? Thanks

[jessicaabela]

Hi i really need this file without the character limit on the UPC column are you able to provide me with it please?
As i want to add my own barcodes in it the do also contain letters which i hope is still possible.

Thankyou for your help

[chicho1219]

n/m (10 char)

Thanks for your help, this is a great Workbook! have a nice day!

[urgoo]

Hi

This is very nice. I need something similar but adding or subtracting different quantities. And I would like to save the changes in other sheet.

If someone can help me that will be great.

[mrice]

Suggest starting your own thread and adding some extra detail including an example workbook.

[pifoam]

Hi mrice,

1. Any idea of removing product ID/status data/row from worksheet automatic using Barcode scanner?
Without clicking additional button.
2. I believe this have to be done so by filter through whole worksheet using macro?

[mrice]

I suggest that you start your own thread with this additional question and include a sample workbook so that potential responders can see the layout of your data.

[pifoam]

Hi mrice & all

I just new on excel VBA. Hope I can gain some help on this. Thanks

That attachment file should be the one that I just edit on by adding remove button on the worksheet.

1. Best that add/removing automatic as a row(product ID/price/status/date) using barcode scanner
2. It should prompt user to scan product description/code/else into the inventory list when it detect that product does exist in the list after barcode scanning.
3. Record of those user that have make changes on inventory list

[Pepe Le Mokko]

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[billfeeney5]

This is great! Any way to copy this to google sheets?

[roastingcoffee2018]

Hi sir,

I Just want to ask, We have bar code scanner. After scan the codes we want its automatically display the corresponding details in other column, How can i make it?

Thanks