Try approaching this with SUMIF. You can read about it's usage in Excel
help. You would need to change the qty for Bastile in your example below to
a negative number. The basic idea would be to subtract what you have used
with the SUMIF function.

Let me know if you have questions.



"Gimme" wrote:

I have a spread sheet which I keep a record of all my sowing (plants)
I want to keep an automatic seed stock count by varity how can I do this.
On my sheet i have
Batch No, Varity, Qty, Customer, Date Sown, Delivery Date,
12345 Bastile 100, van Dyke 12/12 25/02/06

What I want to do is every time I sow Bastile it automaticly takes the
amount off my stock on another sheet .We sow 25 varitys a day so can not
use cell No's must use names but how does excel do this as each name will not
apper in a set cel.
Help please thank you