Excel Form / Inventory List

C

ChrisLouie

Ok long story..... Right now I have created a form in Excel that is connected
to an inventory list in the same workbook. The way the form is set up now is
that I enter a title of a book from a drop down list and the product number
and qty in my inventory automatically pops up. I then enter the qty being
ordered.
My question is, is there a way to automatically update the inventory list
qty by automatically subtracting the qty being requested for that particular
order?

I hope that makes sense!
Thank you,
Christine
 
G

Ginetta

The way the form is set up now is
that I enter a title of a book from a drop down list and the product number
and qty in my inventory automatically pops up.

Change this popup to show the inventory balance and not inventory
total.
My assumptions are; inventory total is what you receive into
inventory.
Your inventory balance would be the inventory less sales made.
I assume you track how many sales you make based on book
criteria? This would be the value you should be tracking and have pop
up
when you enter data into your form.

side note:
You can then add thresholds (values that trigger low volumes and
perform
some task to let you know you need more books).

Hope I understood what you were asking.

Nick
..


I then enter the qty being
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top