Formula cross work book [Closed]

Report
Posts
1
Registration date
Thursday January 28, 2016
Status
Member
Last seen
January 28, 2016
-
Hello,

I am trying to write a formula to automate a stock spread sheet so when a product is sold it deducts from the stock holding, all stock items have a stock number.

I want a formula that would say if the number in column B on page 7 matches the number in column A on pages 1,2,3,4&5 the number in column H on pages 1,2,3,4&5 reduces by one.

if anyone could help that would be fab