Excel 2007 : Excel Table

[ALEZI]

Hello guys,

People from here helped me in the past a lot and I have a hope that you could do this again, probably for most of you it is simple task, basically it is table for counting condition in some warehouse and give data about how much something remains from previous order, how much we ordered in total and how much specific materials arrived, my wish is when I put quantities which arrived, automatically would be subtracted those quantities from remains and at same time to be subtracted from active order on the sheet no.2 (same worksheet),when we spent (got) all quantities from one order and nothing would be left, could delete this row immediately in the table.

Thanks in advance a lot.

[ALEZI]

Hi all,
Could somebody tell what is wrong in my question,if i did not make good question or my question is pretty simple or stupid,please give me some kind of reaction.

I'm completely sure that you can solve my problem.

Thanks in advance