Inventory using Excel

Had a quick programming question (newbie here)

If I wanted to use excel to track inventory in/out, is there any way I can do the following?

I have a barcode scanner and I wanted to be able to quickly add and subtract quantities.

So,

I want to create three fields at the top of list, one with the function to Add 1 to quantity, one to Subtract 1, and one simply to find (well I guess I can use excels find feature, but that would be an extra step)

When I scan a barcode into the "Add 1 to quantity" field (which only appears at the top of the page), excel will automatically add 1 to the corresponding field next to the item that has that UPC number. The same for Subtracting 1.

Thank you all so very much!

This doesn't sound too difficult but would you be able to upload an example workbook? Also what would happen if you opened a blank workbook, set A1 as the active cell, and started scanning a series of items?

Im afraid that I dont understand the second part of your post, but Ive attached a sample worksheet, I hope this will clarify what I am looking to do.

WOW!

Thank you so much!

I tested it briefly and it looks like its exactly what I was looking for- I will have to implement it in action to see if it works for me under real-life conditions.

Thanks!

Glad to help.

I saw this forum and would just like to say thank you! I was looking for a very similar thing - this will help immensely!

I had a few further questions... first, is there any way that you could add an error message when an item is scanned that is not on the UPC list?

Second, would it affect anything if I added a few more columns of description to each item (as long as description, quantity, and UPC remain in the same columns)?

Here is the code modified to pop up an error rather than add the item if the scanned item is not already on the list.

Please Login or Register  to view this content.

Adding extra columns should not mess anything up as long as you keep the existing information in the same columns as you said. Attach the workbook as you'd like to use it if and I will modify the code accordingly if you'd like.

Hi Newbie here just been reading this thread and wanted as how do I adding this module to my work sheet, As this work sheet is exactly what I am looking for to add and subtract stock of my items in the warehouse.

I would be great-full if you could go through how to apply and add this macro to my module.

Thanks again

Hi,

i am stuck with a similar problem and may i know where do i need to enter this code?

Thank you

Hi there,

Willing to pay to have someone implement a similar barcode inventory management solution for my small company. Just need the ability to add/ deduct from my existing account by simply scanning the barcode for the respective item.

I know very little of macros within Excel and am eager to learn.

Please feel free to pm or call me at 713-548-7851.

Thanks!

Hi, please help me with programming (newbie here). I run a small business and would like to keep track of inventory through excel. I have a barcode scanner and wanted to use it to add/subtract quantity. Thank you all so very much! I cannot upload my excel worksheet.

I have been trying to get the code to run and I am unable to. When I scan, the bar code comes up in the cell A4, but it does not populate down C12. Any sugguestions?

I can not seem to ge the Macro to work. I scan, and nothing populated down below. Any ideas or sugguestions?

Why doesn't the code work when I add the module?
The macro doesn't show up when i try to run it.
Please help.

This is perfect.
I have one question. is there any way to record the changes made to say sheet 2. Say there is 1,000,000 items on the list and I want to allow changes to be made to this list but update another db with the changes manualy, daily but need to know what was done. is this possible?

Perfect.
But I need a few changes so that it can fit with my work.