stock inventory

[Ken, San Francisco, Cali.]

I'm trying to create an inventory worksheet(maybe very simple to some of you)
where it has only two columns A(part #) and B(number of part available in
stock). Please help if there is anyway I can just enter part number in
columnA then columnB will automatically adds up quanity of each part I have
in stock. I 'm also using scanner for physical inventory count at the end of
the quarter, how can I write a formula(s) which I just keep sanning and the
the Excel will do the counting works. Thank you very much in advance.

 

[ryguy7272]

Try this:
http://www.vertex42.com/ExcelTemplates/

Look under 'Inventory and Invoices'


Regards,
Ryan---