Automatic inventory updating

[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

[tr]

[TD="width: 424"]I don’t know if what Im asking for is possible in excel preferrably without using VBA[/TD]

[/tr]

[tr]

[td]

In the Master Sheet

[/td]

[/tr]

[tr]

[td]

I want the stock level of each item on each invoice I create to

[/td]

[/tr]

[tr]

[td]

be added to the amount in column T as outgoing stock & to remain after Ive saved the invoice to a folder

[/td]

[/tr]

[tr]

[td]

And likewise for purchase orders items to be added to the amount in column S

[/td]

[/tr]

[tr]

[td]

as incoming stock

[/td]

[/tr]

[tr]

[td]

Im Thinking I may need some means of booking the stock in & out

[/td]

[/tr]

[/TABLE]
[ATTACH]n1214154[/ATTACH]