Hi I'm a newbie here and I'm ok with EXCEL but not with programming.
What I want to do is challenging and demanding, so I am not sure if this can be done in Excel.
I've an apparel shop and want to control stock using a barcode reader.
Well,
There will be 2 fields at the top of Sheet1: one with a function to scan code so that it adds 1 to quantity to the table below, another one with a function to move 1 from the table in Sheet1 to Sheet2 so that it automatically subtracts 1 from Sheet1 and add to Sheet2.
Also in Sheet2, there will be 1 field at the top with a function to scan code to move 1 from the table in Sheet2 to Sheet1.
We have 3 main items in our shop and I'd like to control each item separately, so there will be 3 tables.
I also want to record each item by long(L)/short sleeve(S) and size(XL,L,M), so when I scan the code: G001LXL(G001,long sleeve,XL) in the add field, it automatically adds 1 to its corresponding cell. When I scan the same code in the Move to Sheet2 field, it automatically subtracts 1 from the cell in Sheet 1 and adds 1 to the corresponding cell in Sheet2. So is it for the function in the Sheet2.
I'd be so grateful if anyone helps me.
Please see the attached file to refer.
Thank you all so much.
P.S:
Well, I have this idea because I read a thread posted by someone in this forum with a similar problem. His problem has been sloved and I am really impressed by the way Micro and VBA works.
Please click the URL below to refer.
http://www.excelforum.com/excel-gene...ing-excel.html
Thank you all so much.
Bookmarks