Inventory Manage

[anahigar]

Hi,

I'm totally new on excel and on this forum. But I would try to be the most specific as I can. I use to have a small store where I could keep record with a normal simple excel sheet. But it has come to a point where i think i have to create macros or program with VB. My problem is I have more than 500 products with huge inventory. So i have the idea to make everything faster and easier throught a Barcode Scanner. The problem is now i have my excel sheet with my inventory but i want to be able to scan my products and as in any other store get the name of the product, the price and the total. But so far i couldn't figure out how to do this. The second point is: I want to be able to sell the same product in boxes with 50 and with 500 with different price each one and that only the inventory of this product modify.

This would be an example of my inventory:

Inventory is per unit.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="width: 134"]Barcode[/TD]
[TD="width: 134"]Product[/TD]
[TD="width: 80"]Inventory[/TD]
[TD="width: 162"]Price p/50 pieces[/TD]
[TD="width: 121"]Price p/500 pieces[/TD]
[/TR]
[TR]
[TD]640420001012[/TD]
[TD]Cofee[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]$75.00[/TD]
[TD="align: right"]$670.00[/TD]
[/TR]
[TR]
[TD]640420003016[/TD]
[TD]Cookies[/TD]
[TD="align: right"]45060[/TD]
[TD="align: right"]$65.00[/TD]
[TD="align: right"]$500.00[/TD]
[/TR]
</tbody>[/TABLE]

This would be an example of the ticket that I want to get:

[TABLE="class: grid, width: 491"]
<tbody>[TR]
[TD]Ticket[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barcode[/TD]
[TD]Product[/TD]
[TD]Box[/TD]
[TD]Amount[/TD]
[TD]Unit Price[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]640420001012[/TD]
[TD]Cofee[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$75.00[/TD]
[TD="align: right"]$75.00[/TD]
[/TR]
[TR]
[TD]640420001012[/TD]
[TD]Cofee[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$670.00[/TD]
[TD="align: right"]$2,010.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$2,085.00[/TD]
[/TR]
</tbody>[/TABLE]

<tbody>
[TD="class: xl64, align: right"][/TD]

</tbody>

After sale :


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="width: 134"]Barcode[/TD]
[TD="width: 134"]Product[/TD]
[TD="width: 80"]Inventory[/TD]
[TD="width: 162"]Price p/50 pieces[/TD]
[TD="width: 121"]Price p/500 pieces[/TD]
[/TR]
[TR]
[TD]640420001012[/TD]
[TD]Cofee[/TD]
[TD="align: right"]1950
[/TD]
[TD="align: right"]$75.00[/TD]
[TD="align: right"]$670.00[/TD]
[/TR]
[TR]
[TD]640420003016[/TD]
[TD]Cookies[/TD]
[TD="align: right"]45060[/TD]
[TD="align: right"]$65.00[/TD]
[TD="align: right"]$500.00[/TD]
[/TR]
</tbody>[/TABLE]


I would like any kind of help. I'm very motivated to learn more about Macros and excel.