Take Pimamedic up on getting an example file from him. That'll get you
started.

Remember that in the quantity received and quantity used columns you'll need
to keep undating to include previous entries for the balance on hand to
remain accurate. That is, if you had previously used 5 items and later use
3, you'll have to enter 8 as the quantity used to keep the inventory straight.

While Excel can be used to manage an inventory list, it's not the best or
easiest tool for the job. I just finished up the second of two inventory
management tools for a company and we created them in Excel, and it took some
doing to keep track of it all. But these also track date and quantity of
both received materials and used materials.

P.S. No need to apologize about your level of Excel knowledge - if we all
knew everything, we could shut this board and few hundred thousand others
down later this afternoon :-)

"dam1120b" wrote:

Hi all please help me out. I am new at excel. I need to create a sheet to log
in our inventory and be able to add to it when we get parts in and subtract
from it when the techs take parts. Is there a way to do this?
Thanks and sory to sound stupid.