Hi

I'd wonder if anyone can help. I've put my situation in to simple terms
below .......

I have a column in worksheet 1 which tells me how many oranges I have in
stock. When an order is presented, I enter the details on worksheet 2. Is
there anyway I can enter a formula to check worksheet 1, minus the number of
oranges ordered in worksheet two, and enter the value somewhere in worksheet
2? I'm thinking this would be a good way of telling me when I am low on stock.

Thanks all - used some info on this site before - really brilliant!