Monday, November 16, 2009

How do I set up Excel to record inventory, +when received, -when used = total on hand?

I make wreaths and I need to keep track of all the silk flowers, dried flowers, forms etc that I need to work with. I'm not real good with the formulas for excel. All I need is to add the number received, subtract the number used which equals the number on hand. Quickbooks keeps tract of the actual cost and value of my assets for me. I just want this for my information. Thank you all for your help!!!!

How do I set up Excel to record inventory, +when received, -when used = total on hand?
Drop me your email. I will do one and send it to you. Easier than explaining...just look at my formulas...will only take a minute...really...





Check your email





Is what I gave you what you want?


No comments:

Post a Comment