I've created an inventory spreadsheet.
A10)Item B1)Quantity Sold C1)Price per item x B1 D1)Original Inventory E1)
D1-B1

I'm sure it's simple, but...How can I keep E1 accurate? If I save, then
zero out B1 for the next transaction E1 goes back to =D1

Thanks.

Hi,
why you zero B1, don't you want to keep track of your sales, if you explain
a little more what you want to accomplish I can help

"anjarama" wrote:

I've created an inventory spreadsheet.
A10)Item B1)Quantity Sold C1)Price per item x B1 D1)Original Inventory E1)
D1-B1

I'm sure it's simple, but...How can I keep E1 accurate? If I save, then
zero out B1 for the next transaction E1 goes back to =D1

Thanks.

HI. Thanks.
Well, what I would ideally have is my inventory running in the back ground,
with a dropdown box of available items that could be selected to create a
receipt and atthe same time update my inventory, but I don't think I can
accomplish that with my limited knowledge.
So.. I zero out B1 so that at the end of the transaction C31 will give a
total for the current sale.
Does this help explain?

"Eduardo" wrote:

Hi,
why you zero B1, don't you want to keep track of your sales, if you explain
a little more what you want to accomplish I can help

"anjarama" wrote:

I've created an inventory spreadsheet.
A10)Item B1)Quantity Sold C1)Price per item x B1 D1)Original Inventory E1)
D1-B1

I'm sure it's simple, but...How can I keep E1 accurate? If I save, then
zero out B1 for the next transaction E1 goes back to =D1

Thanks.

Hi,
Look into Debra Webpage, she perfectly explain how to create an Inventory
userform just what you need and it is step by step.

http://www.contextures.com/xlUserForm02.html

if this was helpful please click yes

"anjarama" wrote:

HI. Thanks.
Well, what I would ideally have is my inventory running in the back ground,
with a dropdown box of available items that could be selected to create a
receipt and atthe same time update my inventory, but I don't think I can
accomplish that with my limited knowledge.
So.. I zero out B1 so that at the end of the transaction C31 will give a
total for the current sale.
Does this help explain?

"Eduardo" wrote:

Hi,
why you zero B1, don't you want to keep track of your sales, if you explain
a little more what you want to accomplish I can help

"anjarama" wrote:

I've created an inventory spreadsheet.
A10)Item B1)Quantity Sold C1)Price per item x B1 D1)Original Inventory E1)
D1-B1

I'm sure it's simple, but...How can I keep E1 accurate? If I save, then
zero out B1 for the next transaction E1 goes back to =D1

Thanks.