Stock Control

[Colin1971]

Hi Guys

I have a limited knowledge of excel, but unfortunately I have been volunteered to implement the below:

I want to able to do the following:

1. scan a product in that it registers in excel
2. then scan it into the stock location area
3. then scan the quantities , I presume we have to create bar codes for the quantities
4. when it comes to taking the product out I want to scan it so it registers in excel that its been scanned out with correct amount.

Hope that makes sort of sense and thank you ever so much for your help in advance

Colin

 

[dmt32]

Hi,
welcome to forum

Hi,
What you want to do possibly can be done but likely to be a lot of work & still may not fully offer functionality you may have in mind

Have a read of this thread from another here who had similar request:https://www.mrexcel.com/forum/excel-questions/815221-vba-inventory-stock-program.html

and see if any help to you

Dave