[Help] Creating Auto Sum Quantity

Hello all,

I need help with creating table that:
Table.png

So we have few products at column A, At column B how many quantity of each product we got delivered.
We separate this quantity to 3 stores at column C,D and E.
At column F i need Drop Down Lists were i can chose one of those Stores and when i chose the store below,
to type how many quantity are sold from the current store and the result to go at column G,H and I.
So at this columns G,H and I i need only how many we have left.
At column J all left from all stores and at column K how many we have sold.

P.S. I need to type every time what we sold and to get those results that are collects after each sell.

Sry for my enlish and hope to get help with this impossible for me task
And thanks in advance!

Hi and welcome!
After you choose Store1 in column F - what result do you expect?
Columns G,H and I should be filled automatically? I think you need one more column for "How many is sold".
And please attach sample excel workbook (Go Advanced - Manage Attachments)

If its possible when i chose Store1 in column F and below type that from product 6 i have sold 3 quantity to get how many are left.
If we need more column i think there is no problem with that.
And yes columns G,H and I should be filled automatically after you type how many products you have sold(when i chose Store X in column F)
http://www.excelforum.com/attachment...1&d=1481814079

I have not add columns for this bit if its necessary its ok.
And sry i am newbie

Check my concept of this file.
Columns N:P contains data about sold items for each product/store.
Drop-down in cell F2 will show current store data (sold and left).