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