Inventory control using barcode reader

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.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)