Updating a stock sheet?

[mark.taylor13]

Can anyone help? I need a excel template or ideas of how to create a
stock balance sheet that can be updated when items are removed from
stock. because we have such a large stock, it is a pain going through
each sheet looking for an individual part number to alter its quantity.
i am quite a novice to excel, should i link it with a acess sheet?

 

[Guest]

See:

http://office.microsoft.com/en-us/templates/TC060827171033.aspx